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
- 5719 Views
- Allfon, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Briefly explain what is literal? Give an example where it can be used?
Is oracle the best database?
What does sharding mean?
What is a relational database management system?
what are actual and formal parameters?
What are the different types of synonyms?
How to find out what oracle odbc drivers are installed?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
What is a trace file and how is it created in oracle?
How to drop a tablespace?
What is a trigger and what are its types in oracle?
What are the types of partitions in oracle?
How to Truncate Table in Oracle
What is the database name in oracle?
Who developed oracle & when?
