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
Explain system functions or built-in functions? What are different types of system functions?
How can you manage sql azure security?
What are the 3 types of schema?
What are the indexes in sql server?
Explain DBCC?
How to use values from other tables in update statements in ms sql server?
What do you understand by recursive stored procedure?
What is the meaning of resultset type_scroll_insensitive?
What is the server name in sql server?
Write down the syntax and an example for create, rename and delete index?
What are the different SQL Server Versions you have worked on?
What is etl - extraction, transformation, and loading?
How can sql injection be stopped? : sql server security
What is the command to change the recovery model?
how many clustered indexes can be created on a table? : Sql server database administration