I run that procedure on tables with more than 1,5 millions records in
0,37-0,7 seconds. This is very fast for me!!!



Regards,

Paul



From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of danny_vdw
Sent: Monday, April 30, 2007 4:56 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Optimalisation issues



It works but not fast!

The or conditioning is destroying the usage of the index!

PS
Read everything before posting please.

Van den Wouwer Danny
Peopleware NV





[Non-text portions of this message have been removed]