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
- 4831 Views
- Allfon, I also Faced
- E-Mail Answers
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
Where do we use decode and case statements?
Give syntax for SQL and ORACLE joins.
How to display employee records who gets more salary than the average salary in the department?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
Explain mutating triggers.
What is program global area (pga) in oracle?
What is a user role in oracle?
How to define a sub function?
query optmization techniques and quwry analyser+projects+ppts
Compare and contrast between sql and sql server and explain its various functions?
What is the difference between $oracle_base and $oracle_home?
How to create an oracle database manually?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
what are steps for interface? where is exchange rate defined in which table?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
