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 are the elements of dbms?
Define inner join? Explain with an example?
What are the functions in sql server?
Will sql server 2005 allow you to reduce the size of a column?
Can an automatic recovery be initiated by a user?
How do I view views in sql server?
what are the different stages of Report Processing?
Which table keeps the locking information?
Explain primary key, foreign key and unique key?
When does a workload on SQL Azure get throttled?
What are the differences between user defined functions and stored procedures?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What is the purpose of optimization?
How to get a list of columns in a view using the "sp_columns" stored procedure?
What does sql server mean?
