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 ?
Answer Posted / 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 |
Post New Answer View All Answers
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
How many categories of data types?
What is control file used for?
What is SQL Tuning Advisor in Oracle?
How to find out what oracle odbc drivers are installed?
Difference between the “verify” and “feedback” command?
What is a data dictionary and how can it be created?
Explain a segment?
Difference between oracle's plus (+) notation and ansi join notation?
How to get execution path reports on query statements?
Explain the use of grant option in imp command.
How to execute a stored program unit?
How to create id with auto_increment on oracle?
What do you mean by redo log file mirroring?
How to run create database statement again?