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
- 6074 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 is the difference between post-database commit and post-form commit?
Is it possible to insert comments into sql statements return in the data model editor ?
waht is the difference between primary key and super key?
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
What is ceil and floor in oracle?
which statement is running fastly ie insert or delete?
How to use fetch statement in a loop?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
"primary key=unique+null" is equal,reson?not,reason?
How to get a list of all background sessions in the database?
How can you merge two tables in oracle?
Oracle General 
