I created the following computed index: CREATE INDEX IDX_FNAME ON PEOPLE COMPUTED BY (lower(fname))
This works fine and instead of traversing the entire table when performing a case insensitive query, an 'index read' for matching records is performed. The question I have is that the database management utility I use does not show the true index DDL for my computed index. This is what the utility shows: CREATE INDEX IDX_FNAME ON PEOPLE(); Is my database management tool not showing this correctly or is this what the Firebird server returns?