[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: [email protected] >Admin: http://delphi.org.nz/mailman/listinfo/delphi >Unsubscribe: send an email to [email protected] with >Subject: unsubscribe Ref#: 41006
_______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: [email protected] Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to [email protected] with Subject: unsubscribe
