What are the basic techniques of indexing?



What are the basic techniques of indexing?..

Answer / Devi Dayal

The basic techniques of indexing include creating primary key indexes, unique indexes, and non-unique (regular) indexes. Indexes can be clustered or non-clustered, depending on whether they determine the physical ordering of data in the table. Other techniques include full-text indexing and spatial indexing for textual and geospatial data respectively.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what is sql profiler

2 Answers   Fidelity,


How do I remove sql plus from windows 10?

1 Answers  


What are the limitations of sql express?

1 Answers  


what is HASH join?

2 Answers   Genpact, HCL,


How can you fetch first 5 characters of the string?

1 Answers  


Does access use sql?

1 Answers  


Explian rowid, rownum? What are the psoducolumns we have?

1 Answers  


What are different types of sql commands?

1 Answers  


Does view contain data?

1 Answers  


what is the difference between primary key and unique key? : Sql dba

1 Answers  


In packages the source code is compiled into p code ? how do we describe the p code

3 Answers  


Can we use the cursor's to create the collection in PL/SQL?

1 Answers   MCN Solutions,


Categories