[DUG] Frebird index question

[Leigh Wanstead]

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 <johnkbird at paradise.net.nz> 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: 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