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
indexing ?
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.
2) No
Is This Answer Correct ? | 1 Yes | 0 No |
How do we display rows from the table without duplicates?
How to sort output in descending order in oracle?
How does one get the view definition of fixed views/tables?
How to call a stored function in oracle?
How to convert raw data type into text in oracle? Explain
How to use group functions in the select clause using oracle?
Will you be able to store pictures in the database?
Please explain the difference between outer join and inner join? With examples would be appreciable..!
Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...
10 Answers Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,
Indexes in oracle ?
3 Answers Keane India Ltd, L&T,
How can Oracle users be audited?
How to update values in a table in oracle?