Thanks Wolfgang ... I understand your point ...
I was just trying to be a little cynical ... about these *facts* ... the very elements about which Oracle tells us to rely upon.
1. Who in their right mind would add/drop an index on a live production database without thinking 'A Ha ... dropping this unique key index shouldn't hurt my 10 gazillion row table at all.'?
2. I am now worried about optimizer taking past executions into account ... if you have a person consistently committing mistakes, and you expect this person to learn from his/her experience, what do you think will happen ??
(Stay with me ... it's been a bad morning so far ... a wrong DB was refreshed and someone decided last night to arrange a demo this afternoon.)
Raj
-------------------------------------------------------------
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!
********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2
