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
- 5709 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
When do you get a .pll extension in oracle? Explain its importance
Explain view?
Is rowid unique in oracle?
How does one get the view definition of fixed views/tables?
How to define a specific record type?
Explain the use of file option in exp command.
What is an oracle user account?
how can we store any pdf file in oracle
What is set operator oracle?
What is oracle database 10g express edition?
What is the sql query to concatenate column values from multiple rows in oracle?
How to resolve the ORA-39133 error in Oracle?
How to upsert (update or insert into a table)?
What do you mean by merge in oracle?
what happened to the global index when I truncate the data in one of the partition?
