>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
values)

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