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 to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
What are the dmvs? : sql server database administration
How to create a view with data from multiple tables?
How to get a list of columns using the "sys.columns" view in ms sql server?
Is truncate a dml command?
What is a view and what are its advantages?
Explain what is log shipping?
What command is used to rename the database?
What are logical database components? : SQL Server Architecture
Explain the steps needed to create a scheduled job?
How to view the error log for any specific instance? : sql server database administration
Explain the relational database management system (rdbms)?
What does it mean to invest in the index?
How to enter unicode character string literals in ms sql server?
What is difference between rownum and row_number?
