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
- 5993 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 |
How to create a table in a specific tablespace?
What is a trigger and what are its types?
How to convert csv to table in oracle?
What is Virtual Private Database in Oracle?
What is Data Dictionary Cache in Oracle?
what is the syntax of DELETE command?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Is insert autocommit in oracle?
Display Odd/ Even number of records?
How to define a sub function?
Explain index?
Explain overloading. Can functions be overloaded?
Oracle General 
