Subject RE: [firebird-support] Possible to write this in a way that indices will be used
Author Maya Opperman
>Svein Wrote>Sent: 16 May 2008 09:12 AM
>>if you want to, you may of course specify the entire PLAN explicitly
in your select statement
Will look that up in Helen's book, thanks!

>>I know of a few tricks how to prevent an index from being used
Please share! (If they can be applied dynamically depending on input

>>you're not going to get equally good performance as you would if your
WHERE clause were determined dynamically.
I can't do that from within a stored procedure, can I?

>>You may end up choosing to do things in a way that users 'normally'
will be content with.
Problem for me here is, use of each is pretty much 50/50, not 99 to 1.