How can I enforce to use particular index?
Answer / saravakumar
You can use index hint (index=index_name) after the table
name. SELECT au_lname FROM authors (index=aunmind)
|Is This Answer Correct ?||7 Yes||0 No|
1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?
can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?
What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)
What are indexes? When do you need to create Indexes?
What is the best way to move n number of DTS package from one SQLServer to another SQLServer?
Explain Capacity planning to create a database? and how to monitor it?
Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?
How get current date in SQL server 2000
last function used in MS Access to convert sql what function will use in sql
user defined datatypes
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
What is a Join in SQL Server?