[DUG] Frebird index question

[Rohit Gupta]

Yes, the index creation is immediate. It is most likely that

 1. your query is not using the index (look at the plan)
 2. your index is not specific enough.

Solutions

 1. If you have two indexes that could be used (looking the where or
    order by clause) then firebird will use the index with the best
    selectivity.  You may have to rebuild the indexes to fix the
    selectivity if its wrong.  Or change your where clause - you put in
    dummy clauses to coax it.
 2. Maybe you need a multi-field index.  Also note that firebird will
    use the fields with fixed (non range/between) values to determine
    the index to use first.


Post your query and the index you are trying to use.

Rohit


On 29/10/2012 9:26 a.m., John Bird wrote:
> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20121105/4d556f6e/attachment.html