At 11:46 AM 12/5/2000 +0100, Bram wrote:

>
>SELECT STREET FROM POSTCODE WHERE STREET CONTAINING 'BRAM'
>
>There are actually 130 streets in Holland containing my first name. But it
>takes about 10/15 seconds before its returning the 130 rows with an
>IB_Query set on active. Is there a way to check if the query is 100% optimized.
>
>Could it go faster ?

The containing operator can not use indexes, so it must read
all records. If you are looking for streets starting with "Bram"
either the starting with operator or like "Bram%" is optimized
with an index.


Regards,

Ann
www.ibphoenix.com
We have answers.