Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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 ?

Answers were Sorted based on User's Feedback



can anyone help me ? an index has been done on the primary key of a table. an update operatio..

Answer / 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

can anyone help me ? an index has been done on the primary key of a table. an update operatio..

Answer / 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

More Oracle General Interview Questions

what are archived logs?

0 Answers  


What is varray?

0 Answers  


What are the differences between char and nchar in oracle?

0 Answers  


What is a package in oracle?

0 Answers  


How to loop through a cursor variable?

0 Answers  






what is difference between table and view? where to use views? thanks in advance!

1 Answers  


What do you mean by merge in oracle?

0 Answers  


Define the terms primary key foreign key and also the difference between primary and the unique key

2 Answers  


Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

0 Answers   Microsoft,


Which is faster join or subquery in oracle?

0 Answers  


What is meant by an index?

0 Answers  


How to shutdown your 10g xe server from command line?

0 Answers  






Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (509)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)