Interested to Buy Any Domain ? << Click Here >> for more details...
How can I enforce to use particular index?
- 1 Answers
- 6180 Views
- Symphony, I also Faced
- E-Mail Answers
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 |
How to use clusters?
What are sql servers used for?
What is a result set object returned by odbc_exec()?
you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required
What is the default value of an integer data type in sql server 2005?
What is Transparent Data Encryption?
How do I partition a table in sql server?
Is there any difference between the primary key and unique key?
What is importing utility?
What are the differences between UNION and JOINS?
3 Answers CarrizalSoft Technologies,
what is denormalization and when would you go for it? : Sql server database administration
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
-
Oracle (3259) - 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)
