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 can you implement data mining in ssrs?
What is the default fill factor value?
What are the underflow and overflow behaviors on float literals?
Will the writetext statement activate a trigger?
What does REVERT do in SQL Server 2005?
What is the difference between nvl and nvl2?
what happens on checkpoint? : Sql server database administration
What is user-defined function?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
How to generate create view script on an existing view?
How many tables can be joined in SQL Server?
Can select statements be used on views in ms sql server?
Why do we use functions?
How to create an index on an existing table in ms sql server?
what are database files and filegroups? : Sql server database administration
