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
- 497 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
More MySQL Interview Questions
How do I run mysql?
What is the difference between a Table and a View?
What is the difference between now() and current_date()?
How many rows mysql can handle?
What is the command used to create a database using php and mysql?
Can you save your connection settings to a conf file?
Write a query to display current date and time?
Is mysql a server?
date funciton
How do I stop a mysql command?
What is the difference between timestamp and datetime in mysql?
What is mysql command line?
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)
