Interested to Buy Any Domain ? << Click Here >> for more details...
We create an index to fast the search. How it fast the
query? Do we write any special keyword with query?
- 3 Answers
- 5705 Views
- I also Faced
- E-Mail Answers
Answer Posted / laxman
we need to use indexed column in where clause
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
How to enable tcp/ip protocol on a sql server?
What is use of @@ spid in sql server?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is the difference between index seek vs. Index scan?
What is delete query?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What is t-sql script to take database offline – take database online.
Define full outer join?
Explain about builtinadministrator?
Explain primary key and foreign key constraints?
What are the difference between “where” and “having” clause in sql server?
Define Joins?
do you know how to configure db2 side of the application? : Sql server database administration
What are built in functions?
