Hi John, I am not sure about Firebird v2.
In mysql I will use describe and mssql I will use sql enterprise manager to look at which index the query use. I imagine that you can do the same thing in Firebird. Regards Leigh On 29 October 2012 09:26, John Bird <[email protected]> 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 > > _______________________________________________ > 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 _______________________________________________ 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
