>> -----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.

yes I can imagine that... unfortunately I don't have access to the source
of the program :-(
Is there a way to see the queries that are sent to the server?

>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/