Re: indexes

Read below: >-----Original Message----- >From: "tomcaml@yahoo.com" <tomcaml@yahoo.com> >To: informix-list@iiug.org >Date: 2 Mar 2005 09:28:27 -0800 >Subject: indexes > >hello > >stull fuzzy on index retrieval and the order of the >indexed fields.... > >if i have a table with these columns indexed (col1, >col3, col4) >and the sql says col1, col4, col3 does the index What you mean by sql says "col1, col4, col3" ? >still get used or >does it stop at col1 because of the order? No. > >i assume always using the exact order of fields in the Order of fiels? that not matter to the informix optimizer. >sql to match the >indexes is the way to be correct but am unsure about >different orders >or if the sql has two out of four included but they >are either in the >same order or ordered differently. > I think you better give an example of what you're trying to do. >thanks in advance! > >tom > J. Jean Sagi jeansagi@myrealbox.com jeansagi@yahoo.com sending to informix-list