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
- 5911 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 |
What is SAVE POINT ?
what are the different types of cursors? explain?
How do I connect to oracle database?
Explain an exception and its types?
What is a snapshot log?
How do I limit the number of rows returned by an oracle query after ordering?
What are main difference between Stored Procedure and Functions.
what is a cartition product?
can we pass two out parameters at a time in function?please answer to my question
How data locks are respected in oracle?
How to drop an index?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
Oracle General 
