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

Post New Answer

More MySQL Interview Questions

What is mysql primary key?

0 Answers  


about join

2 Answers  


What is Inner Joints and Outer Joints ? What is right outer joints,left outer joints,right inner joints , left inner joints ,

2 Answers   HP,


What are mysql data types?

0 Answers  


How do I change the max connections in mysql?

0 Answers  






Is mysql free software?

0 Answers  


Is mysql a nosql database?

0 Answers  


Is mysql a backend?

0 Answers  


How can we store binary data in mysql?

2 Answers   HP,


How to add a new column to an existing table in mysql?

0 Answers  


suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?

0 Answers   ACC,


How database are managed?

0 Answers  


Categories