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 is the difrence between sql and pl/sql
What are the differences between char and varchar data types?
Can you tell how to find the number of rows in a resultset using php?
If you wish to encrypt the username and password using php, how will you do that?
What is csv?
How to rename an existing table in mysql?
What is the command line end user interface - mysql?
Is mysql workbench a dbms?
How can I change database in mysql?
What is sqlyog?
What is the function of myisamchk?
how to dump all databases for backup. Backup file is sql commands to recreate all db's.
Oracle (3253)
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)