> -----Original Message-----
> From: Yves Glodt [mailto:yg@...]
> Sent: Friday, October 24, 2003 9:22 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Index question
>
>
>
> Hello,
>
> we are trying to enhance performance of an application we
> resell. It has about 50 tables, and one of them contains many
> rows of calculated data (about 1300000). The field IPN is the
> persons id who the data belongs to. With 45 persons, that
> makes ~28000 records per person. Selects are mostly made of
> the 5th column, with the first 4 columns in the where-clause.

You'd probably get better help by sending a query that seems to be slow,
along with the plan that FB used.

Without example queries it's very difficult to offer index suggestion.