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 are the types of indexes?
What is difference between inner join and join?
What happens if strings are casted into wrong code pages in ms sql server?
List the various tools available for performance tuning?
How to store pdf file in sql server?
1 Answers CarrizalSoft Technologies, College School Exams Tests, TATA,
What is a transaction and what are ACID properties?
Explain what is meant by replication of database?
Can you type more than one query in the query editor screen at the same time?
Why should we go for stored procedures? Why not direct queries?
How to create user defined functions with parameters?
Are semicolons required at the end of sql statements in sql server 2005?
What's the purpose of Stored Procedure?
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)