Re: pros and cons (now: KEEP INDEX)

On 04/01/2004 08:08:04 PM, Connor McDonald wrote:
> Has anyone come up with a reason why you'd want the concept of a KEEP INDEX option? Consider the
> scenarios

Connor, I have to confess, I looked that option up in the SQL reference manual when you mentioned it and, quite frankly, I don't know where to use it. If I want to drop unique constraint, then I don't want to leave the mechanism that enforces it in place. The only guys who will find that option useful are the authors of "advanced SQL" books and the teachers of advanced SQL courses.

-- 
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------