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
What does mysql_query return?
Explain % and _ inside like statement?
What is offset limit?
In mysql, what is joins? Explain
What are slow queries?
What is database in php mysql?
Explain the different types of constraints?
What is the difference Delete and Drop ?
Is mysql a database?
how to Return total number of rows.
What is timestamp in mysql?
What is the default port for mysql and how it can change?
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)