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 |
Write a program using SQL queries to find a unique entry in a table.
Explain encryption of entire databases without the need for application changes in sql server 2008?
Why truncate is ddl?
What is function of CUBE ?
What is not null constraint?
In clustered and non clustered indexes which one is faster while executing a query ?
What is clr ddl trigger?
What are the steps you will take, if you are tasked with securing an SQL Server?
What are three major types of constraints?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
What is Sqlpaging in SqlServer 2005 ?
How ssrs maintain security?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)