[DUG] Frebird index question

[Gary T. Benner]

[Reply]

HI John,

> is the existing data indexed immediately on creating the index?


Yes it is.

Of course the situation will depend upon your query and the metadata in question.

FYI,  if you use the Firebird specific "containing" keyword in your query this does not use indexes.

cheers

Gary


At 09:28 on 29/10/2012 you wrote 
>This is a multi-part message in MIME format.
>
>
>
>
>Firebird V2
>
>I have a large table (5,500,000+ records) that I just added an index to to speed some queries.   So far it has not made much difference - is the existing data indexed immediately on creating the index?
>
>John Bird
>
>
>_______________________________________________
>NZ Borland Developers Group - Delphi mailing list
>Post: delphi at listserver.123.net.nz
>Admin: http://delphi.org.nz/mailman/listinfo/delphi
>Unsubscribe: send an email to delphi-request at listserver.123.net.nz with Subject: unsubscribe

Ref#: 41006

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20121029/728c396a/attachment.html