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
- 5988 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 call a sub procedure?
What is a user role in oracle?
How to get the Installed Oracle Version Information ?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
Explain do view contain data?
Explain view?
What is format trigger?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How to write text literals in oracle?
How to upsert (update or insert into a table)?
When system tablespace is created?
What happens if the update subquery returns multiple rows?
What is a tns service name?
Explain the use of owner option in exp command.
What is ordinary table in oracle?
