Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?
- 0 Answers
- 505 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
More MySQL Interview Questions
What are the functions of mysql?
how to take mysql database backup?
What does mysql flush hosts do?
How can I remotely connect to mysql database?
What does mysql workbench do?
How do I flush privileges in mysql?
How do I switch users in mysql?
What is the hostname for mysql database?
How does limit work in mysql?
Is mysql a scripting language?
Is mysql a server?
How do I view tables in mysql workbench?
Categories
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
