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
- 5775 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 a dead lock in oracle?
How to recover a dropped table in oracle?
How to Truncate Table in Oracle
How to call a stored procedure inside a trigger? Give an example.
What are various constraints used in SQL?
can you explain performance tunning in oracle(sql,PL/SQL)
Can group functions be mixed with non-group selection fields?
Where are the settings stored for each instance in oracle?
What is E-R diagram ?
2 Answers CGI, Keane India Ltd,
What is a materialised view?
how to retrieve daily sal from emp table in oracle 10g
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Oracle General 
