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
- 5841 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
How to start instance with a minimal initialization parameter file?
Explain the use of file option in exp command.
How to login to the server without an instance?
What are the attributes that are found in a cursor?
if you ctreate table identity
How do you store pictures in a database?
Explain the types of exception?
Explain user account with reference to oracle.
What is index-organized table in Oracle?
How to revoke create session privilege from a user in oracle?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What are the different windows events activated at runtime ?
What are the different types of record groups in oracle? Explain each of them
How to create a stored function in oracle?
Explain a private synonyms?
