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 |
what is sql profiler
How do I remove sql plus from windows 10?
What are the limitations of sql express?
what is HASH join?
How can you fetch first 5 characters of the string?
Does access use sql?
Explian rowid, rownum? What are the psoducolumns we have?
What are different types of sql commands?
Does view contain data?
what is the difference between primary key and unique key? : Sql dba
In packages the source code is compiled into p code ? how do we describe the p code
Can we use the cursor's to create the collection in PL/SQL?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)