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
What the difference between UNION and UNIONALL?
Explain how you can deploy an SSRS report?
What are the drawbacks of reporting in ssrs?
What is entity data services?
How to create a new table in a given schema?
How to change the data type of an existing column with "alter table" statements in ms sql server?
How to use subqueries with the in operators in ms sql server?
How to enable tcp/ip protocol on a sql server?
What is microsoft sql server?
What is data modeling and Reterminal integrity?
What is executereader?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
How to convert binary strings into integers in ms sql server?
Why do we use non clustered index?
Tell me what is difference between view and materialized view?
