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
- 5852 Views
- Allfon, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / patilshashi
1) Slower due to frequent updating , if their is bulk
updation then disable the constraint and then enable it.
2) No
| Is This Answer Correct ? | 1 Yes | 0 No |
Explain what are the characteristics of data files?
What is a snapshot in oracle database?
Give syntax for SQL and ORACLE joins.
14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth
How to empty your oracle recycle bin?
What are the data types in oracle?
When does a Transaction end ?
What is autonomous transaction?
Explain the importance of .pll extension in oracle?
what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
Oracle General 
