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
- 4845 Views
- Allfon, I also Faced
- E-Mail Answers
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 |
Explain the dml?
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL
can u plz provide me oca sql dumps please i need them
How can you use check constraints for self referential integrity?
What is a data dictionary and how can it be created?
What do you mean by a deadlock?
How to create lov dynamically at runtime & attach to text field?
how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........
what is the syntax of DELETE command?
What is the difference between substr and instr?
What are the data types in oracle?
What is translate in oracle?
Oracle General 
