What is an Index?
Answers were Sorted based on User's Feedback
Answer / srinivas
Index is a database object which improves the efficiency of
the query
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / guest
When queries are run against a db, an index on that db
basically helps in the way the data is sorted to process the
query for faster and data retrievals are much faster when we
have an index.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / uma
index is used to speed up query execution,indices are used
to locate the tables in the database.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is difference between count (*) and count 1?
what is the use of database index(apart from the last searching of records) and what is the use of composite key?
What is the difference between locking and multi-versioning?
What is self contained sub query?
What is the impact on other user sessions when creating indexes?
How network traffic be reduced by using the stored procedure?
How to drop an existing table with "drop table" statements in ms sql server?
Explain filtered indexes benefits?
How to return the second 5 rows in ms sql server?
How to resolve the orphan use problem? : sql server security
Describe in brief system database.
What are mdf,ndf,ldf files and how to see the data in those files?
Oracle (3259)
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)