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?
No Answer is Posted For this Question
Be the First to Post Answer
How do I change directories in mysql?
What is mysql routine?
What is action query?
What is a scalar function?
how to Return total number of rows.
How do you rename a table?
How to get current MySQL version?
What does mysql flush hosts do?
Have you ever used MySQL Administrator and MySQL Query Browser? Describe the tasks you accomplished with these tools?
What is the difference between char and varchar in mysql?
How do I clear a mysql database?
Is sql similar to mysql?
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)