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
- 5881 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
Why use resource manager in Oracle?
What are the types of partitions in oracle?
Explain what are clusters?
How do I limit the number of oracle database connections generated by weblogic server?
Is oracle a language?
Explain rename?
How to use "while" statements in oracle?
What is ceil and floor in oracle?
Explain implicit cursor.
What are the differences between number and binary_float in oracle?
Can we create trigger on materialized view in oracle?
What does sharding mean?
defination of bitmap index
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How to export data to a csv file?
