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 ?
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
What is a partition in oracle?
How many types of tables supported by oracle?
Can we create database in oracle using command line ?
What is a connect identifier?
Where are the settings stored for each instance in oracle?
Explain an index?
Point out the difference between user tables and data dictionary?
Explain the difference between sap and oracle?
How do we represent comments in oracle?
what is dynamic SGA and static SGA
What is system global area (sga) in oracle?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What happens to the current transaction if the session is killed?
How to export data with a field delimiter?
Why use resource manager in Oracle?