INDEX questions...about speed

Posted in 1993

cheryl@redriverad-emh1 — Wed, 28 Jul 93 14:43:18 CDT — source: Informix-list mailing list archive (1991-1998)

Jeff, You and some of the others are probably much more knowledgeable about SQL queries than I am but... For mathmetical comparison and I think for basic SQL the system looks first within parenthesis and then to the rest of the statement. In your view you have only the matches statement in parenthesis which would imply a sequential scan and would start ignoring any index. Is this correct? It has been my experience that "c between a and b" works more efficiently than "c >= a and c <= b". What would happen if you put parenthesis around the first part of the statment? You sent so much information, not a simple sql statement, that I got confused. cheryl gross (903) 334-3518 Red River Army Depot Texarkana, TX cheryl@redriverad-emh1.army.mil