We create an index to fast the search. How it fast the
query? Do we write any special keyword with query?

Answer Posted / nixo

In the case search is the query. How would you search in
the database? I think you will use sql query.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to recompile stored procedure at run time?

565


Explain about local stored procedure?

504


How do I create an extended event in sql server?

485


What is the difference between coalesce() & isnull()?

530


What is de-normalization and what are some of the examples of it?

531






you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

548


How do you delete duplicate rows in sql server?

506


What is the default sql server instance name?

558


Define msdb database?

596


What are the recovery models in sql server 2000?

556


What is lock escalation? : sql server database administration

592


How do clustered indexes store data?

613


How to provide values to stored procedure parameters in ms sql server?

529


Tell me what is log shipping?

567


Define clusters?

643