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
How to find index size for each index on table?
Explain left outer join and right outer join?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
If any stored procedure is encrypted, then can we see its definition in activity monitor?
How to insert data into an existing table?
What command would you use to create an index?
What is named query? : sql server analysis services, ssas
What is the difference between stored procedure and user defined functions?
What is the syntax for encrypting a column in SQL Server?
Ways to improve the performance of a SQL Azure Database?
Relational calculus is what type of language?
What is a database in ms sql server?
What is difference between rollback immediate and with no_wait during alter database?
How to provide column names in insert statements in ms sql server?
