Hi,

> Do I need to create index for foreign key field? Where I can find info
> about creating indexes to optimise selects.

Firebird automagically creates indices for all your FKs.

>I want to make my selects
> work fast and make no unusefull indexes.

Don't we all.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com