--- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:

> The problem is with this statement:
>
> /*---
> PREPARE STATEMENT
> TR_HANDLE = 14555516
> STMT_HANDLE = 14555588
>
> SELECT RDB$FIELD_NAME
> FROM RDB$INDEX_SEGMENTS
> WHERE RDB$INDEX_NAME = ? /* Name */
> ORDER BY RDB$FIELD_POSITION ASC
>
> PLAN SORT ((RDB$INDEX_SEGMENTS INDEX (RDB$INDEX_6)))
>
> FIELDS = [ Version 1 SQLd 1 SQLn 30
> RDB$INDEX_SEGMENTS.RDB$FIELD_NAME = <NIL> ]
>
> SECONDS = 0.170
> ----*/
>
> You must have a LOT of indexes defined in your database. Just for

kicks, try

> putting an index on the
>
> RDB$INDEX_SEGMENTS
>
> table for the
>
> RDB$INDEX_NAME
>
> column and another index on the
>
> RDB$FIELD_NAME
>
> column.
>
> Let me know how it goes.
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com

No change. There was already an index for RDB$INDEX_NAME and I added
an index for RDB$FIELD_NAME.