What is Index and different types of Indexes?

Answer Posted / joe

4 different types of index

1.Clustered
2.Non Clustered
3.Primary XML
4.Spatial

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to view existing locks on the database?

539


Explain the use of ignore option in imp command.

563


What is instant client oracle?

533


How to insert multiple rows with one insert statement in oracle?

562


Explain drop constraint oracle?

584






WHAT IS ecc 6.0

1644


How to connect to a local oracle 10g xe server?

522


Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1563


In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1354


What is a proxy class?

549


What is the difference between $oracle_base and $oracle_home?

574


State the various uses of dbcc command?

539


What are the major difference between truncate and delete?

509


How do I connect to oracle?

554


how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

1580