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
- 5842 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
How to call a sub procedure?
What is the relation of a user account and a schema in oracle?
what is meant by magic query
How to create a new table in your schema?
What is primefaces used for?
What are transaction isolation levels supported by oracle?
what is Single Byte Overhead...?
Is oracle a relational database?
What is the Tune Query
What is recovery manager(rman) backup in Oracle?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
Can select statements be used on views in oracle?
What is an oracle wallet?
what are bitmap indexes? How does they work?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
