Path: utzoo!utgpu!watmath!clyde!att!osu-cis!tut.cis.ohio-state.edu!cwjcc!hal!ncoast!allbery From: allbery@ncoast.UUCP (Brandon S. Allbery) Newsgroups: comp.databases Subject: Re: Is order important in SQL? Message-ID: <13088@ncoast.UUCP> Date: 13 Nov 88 18:32:01 GMT References: <344@sunny.UUCP> <13087@ncoast.UUCP> Reply-To: allbery@ncoast.UUCP (Brandon S. Allbery) Followup-To: comp.databases Distribution: na Organization: Cleveland Public Access UN*X, Cleveland, Oh Lines: 18 As quoted from <13087@ncoast.UUCP> by allbery@ncoast.UUCP (Brandon S. Allbery): +--------------- | I've never seen any effect of ordering in Unify SQL. (I *have* seen an | effect in Informix-SQL: "where" clauses seem to be executed in "bottom-up" | order of conjunctions.) +--------------- I should point out that the version of Informix-SQL where this was observed is neither current nor even particularly recent. It *is* one of the 2.x releases, though. I have no idea how well more recent versions optimize. ++Brandon -- Brandon S. Allbery, comp.sources.misc moderator and one admin of ncoast PA UN*X uunet!hal.cwru.edu!ncoast!allbery ncoast!allbery@hal.cwru.edu allberyb@skybridge.sdi.cwru.edu allbery@uunet.uu.net comp.sources.misc is moving off ncoast -- please do NOT send submissions direct Send comp.sources.misc submissions to comp-sources-misc@.