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 |
Difference between 2NF &3NF ?
How many cores do I need for sql server 2016?
one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
What are the types of indexes available with SQL Server?
Explain where clause?
what is a transaction? : Sql server database administration
What is built-in function?
How to list all dsn entries on your local machine using odbc_data_source()?
How can you see what type of locks used?
What is store procedure? When do you use?
What happens if you delete a table that is used by a view?
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)