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 / 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 |
Post New Answer View All Answers
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
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.
Differentiate between function and procedure in oracle.
What is a nested table?
What does sharding mean?
Explain an integrity constrains?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
In the oracle version 9.3.0.5.0, what does each number shows?
Explain about integrity constraint?
What is transaction control statement and how many types of transaction control statement in Oracle?
State the difference between a primary key and foreign key?
How to export data to a csv file?
How to change user password in oracle?
How to drop an existing view in oracle?
How to check database size in Oracle?