Subject Re: [firebird-support] indices
Author Martijn Tonies

> I have a table with about 18000 rows and i had no indices defined.
> I have a query with about 10 joins of this table and other tables in
> DB. It takes very long time. Now i have defined the indices by a
> fields which are used in JOINs.
> How do i force the DB to build the index for rows which are already in
> DB? Because it doesnt look like the query is now using the new indices.

If you create the index, it will be calculated.

Depending on your query, the indices might be useful or not, hard
to tell without any information.

Have you looked at the "query plan" to see if the indices are used?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!