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
- 5714 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
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
Please explain drop constraint oracle?
What is a private synonym?
What are the ansi data types supported in oracle?
How to convert a date to char in oracle? Give one example.
What is a Garbage Collection? and what is full recursive Garbage collection?
Why should I use oracle database?
How to create a new table by selecting rows from another table?
How to empty your oracle recycle bin?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
Who developed oracle & when?
How to start instance with a minimal initialization parameter file?
State some uses of redo log files?
Why is oracle so popular?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
