what are the optimization techniques for
Query optimization
performance issues and
faster execution of queries
Answer Posted / jawed
User the following
1.litmit
2.keys
3. indexing
Is This Answer Correct ? | 23 Yes | 6 No |
Post New Answer View All Answers
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 is difference between schema and table?
What is select query in mysql?
How to validate email addresses in mysql?
What is the data source name for mysql?
How can you retrieve a particular number of records from a table?
How can we get the number of rows affected by query?
Is mysql a server or database?
What is the phantom problem?
What is difference between microsoft sql and mysql?
Do while loop in mysql procedure?
How do I view mysql logs?
What do ddl, dml, and dcl stand for?
What is a csv table?
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?