How many different types of indexes we have in oracle?

Answer Posted / nimisha

Implicit index and Explicit index.

Is This Answer Correct ?    63 Yes 29 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

1784


What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

522


Explain the use of parfile option in exp command.

523


Give the various exception types.

542


How to update a table row with a record?

597






What are named parameters?

612


How to create a temporary table in oracle?

692


How to change program global area (pga) in oracle?

582


How to declare a local variable?

592


What is max rowid in oracle?

551


How do I call oracle stored procedures that take no parameters?

562


How to use "out" parameter properly?

628


How to establish administrator authentication to the server?

558


How to create a table index in oracle?

659


Explain about achiever in sql?

584