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
- 5990 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
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What are the various types of snapshots ?
What is oracle thin client?
How to define a data field as not null?
What is archive log in Oracle?
What's dateware house and what's clustor with practicle example
How to initialize variables with default values?
Compare and contrast between sql and sql server and explain its various functions?
What is oracle latest version?
How can I combine multiple rows into a comma-delimited list in oracle?
Is rowid unique in oracle?
What happens if you lost a data file?
Can we call procedure inside function in oracle?
List the various oracle database objects?
