Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / lekhraj deshmukh
An index covers the query if all the columns specified in
the query are part of the index. These are the columns that
are all columns referenced in the query, not just columns in
a WHERE clause.
eq:-SELECT DISTINCT lower(orig_airport) FROM Flights
here orig_airport is a index column.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How do you delete duplicate records in sql server?
How to maintain a fill factor in existing indexes?
What is database mirroring?
Explain the various types of concurrency problem?
Explain about system database?
What is user-defined multi-statement table-valued function?
Tell me what are the essential components of sql server service broker?
What is difference between count (*) and count 1?
what are isolation levels? : Sql server database administration
what does the automatic recovery do? : Sql server administration
What is scd (slowly changing dimension)? : sql server analysis services, ssas
What is the usage of sign function?
How to create a user name in a database?
How to insert data into an existing table?
When to use Inner join & when to use subquery?
