can anyone help me ?
an index has been done on the primary key of a table. an
update operation was performed on that table.
now my question is
1> what abt the performance ? means faster or slower due to
2> does the operation affect to the primary key constraint ?
Answers were Sorted based on User's Feedback
Answer / dinesh a.
If you have a primary key there is no need to create one
explicitly index on that , Oracle create implicitly index
on your primary key .
We create index on a table to fast access (ie retrive) so
your data accessing will be fast but same above asnwer in
case of DML operation the performance will get slow.
|Is This Answer Correct ?||3 Yes||0 No|
Answer / patilshashi
1) Slower due to frequent updating , if their is bulk
updation then disable the constraint and then enable it.
|Is This Answer Correct ?||1 Yes||0 No|
what are archived logs?
What is varray?
What are the differences between char and nchar in oracle?
What is a package in oracle?
How to loop through a cursor variable?
what is difference between table and view? where to use views? thanks in advance!
What do you mean by merge in oracle?
Define the terms primary key foreign key and also the difference between primary and the unique key
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
Which is faster join or subquery in oracle?
What is meant by an index?
How to shutdown your 10g xe server from command line?