Enable and Disable constarint
tell if i do enable and dissable the constraint , it will create the index on new records or not.
Or i have to give the alter index rebuild claues for the rebuilding the index.Please tell me the command also
thanks in advance
No problems Go on Enabling and disableing constraints. Oracle server will manage the indexes associated with primary key/unique constraints.
whenever u disable constraint Oracle will drop the Index and when u enable again it will create index.
A Wise Man Knows How much he doesn't know !!!
If you have a need to disable and enable PK or unique constraints, create the supporting index before you create the constraint, and DO NOT make the index unique. It will then be used to help enforce the constraint, but will not be dropped/rebuilit when you disable/enable the constraint.
Also consider whether a DEFERRABLE constraint would be a better option for your situation
Click Here to Expand Forum to Full Width