Interested to Buy Any Domain ? << Click Here >> for more details...
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 ?
- 2 Answers
- 5894 Views
- Allfon, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to count duplicated values in a column in oracle?
What to do if the binary spfile is wrong for the default instance?
How can we view last record added to a table?
What is an oracle user role?
How to start a new transaction in oracle?
Explain a segment?
How to calculate date and time differences in oracle?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
What is the exact use of Collections?
Difference between hot backup vs. Cold backup?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
How to insert a record into a table?
What are the ways tablespaces can be managed and how do they differ?
How can I create database in oracle?
What is proxy method?
