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
- 5898 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 |
what are Triggers?
What is the quickest way to fetch the data from a table?
How view is different from a table?
How to assign a table row to a record variable?
what is difference between DBMS and RDBMS?
You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
What are the restrictions on external table columns?
How to assign data of the deleted row to variables?
Why does oracle 9i treat an empty string as null?
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.
How do I uninstall oracle 11g?
Is there a function to split a string in plsql?
Oracle General 
