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

What type of locking occurs during the snapshot generation? : sql server replication

874


What is the difference between DataRow.Delete() and DataRow.Remove()?

750


What are sql server functions?

526


What is set nocount on?

511


what are the three command line utilities and what are their primary functions?

103






How many databases Microsoft SQL server provides?

620


Explain log shipping and mention its advantages.

608


How to fine-tune reports?

153


Can you use order by when defining a view?

577


Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

584


What is the primary use of the model database?

636


Define Joins?

623


What do you understand by a stored procedure?

621


How can you start sql server in different modes?

515


How to turn off warning messages during php execution?

540