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
table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases
What are the difference between now and current_date in mysql?
How to see the database architecture in MySQL??
Does mysql need a server?
What is Database?
What does mysql flush privileges do?
Which is better mysql or mssql?
what if you really want to store the timestamp data, such as the publication date of the article?
What are the critical issues you have resolved in your company
How many primary keys can be there in a table?
How to make a copy values from one column to another in mysql?
How do I switch users in 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)