|Subject||RE: [firebird-support] Possible to write this in a way that indices will be used|
>Svein Wrote>Sent: 16 May 2008 09:12 AMin your select statement
>>if you want to, you may of course specify the entire PLAN explicitly
Will look that up in Helen's book, thanks!
>>I know of a few tricks how to prevent an index from being usedPlease share! (If they can be applied dynamically depending on input
>>you're not going to get equally good performance as you would if yourWHERE 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.