Don't forget you can also force indexes out by doing things like:

adatecol + 0 > [some value]

This forces interbase to not use an index on that column. With large tables
it is known to toss in indexes it has no use for.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Svein Erling Tysvær" <svein.erling.tysvaer@...>
To: <ibobjects@yahoogroups.com>
Sent: Wednesday, July 11, 2001 3:51 AM
Subject: Re: [IBO] SQL statement takes longer to open on a smaller identical
DB.....


> Strange, I see no reason for any of these queries to be slow. Good you
> found one that works, but check your indexes when you get time - "the
> possibility of duplicate indexes on columns being used in joins" may well
> be the reason for the first two being so slow.
>
> Set
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>