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 |
WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...
What are the new features in SQL Server 2005?
What is the use of DBCC commands?
What is sql profiler. What are the default templates with it? : sql server database administration
What is an index. What are the types?
Can we use pragma autonomous_transaction in trigger?
What is the difference between a stored procedure and a user defined function?
Explain about extended stored procedure?
Are null values the same as that of zero or a blank space?
Name the different type of indexes in sql?
How to create nested stored procedure?
How do I find the transaction log size in sql server?
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)