MCQOPTIONS
Bookmark
Saved Bookmarks
→
Structured Query Language (SQL)
→
Status Variables in Structured Query Language (SQL)
→
To check how MySQL would execute a SELECT query, w..
1.
To check how MySQL would execute a SELECT query, which statement is used?
A.
TELL
B.
SHOW
C.
DISPLAY
D.
EXPLAIN
Answer» E.
Show Answer
Discussion
No Comment Found
Post Comment
Related MCQs
The optimizer_prune_level is set by default.
Which system variable tells how far into the rest of each incomplete plan the optimizer should look to evaluate whether it should be expanded further?
Which system variable tells the optimizer to skip certain plans based on estimates of the number of rows accessed for each table?
What are the results of the following SQL commands if col is an integer column?
Which of the following WHERE clauses are faster?
WHICH_SYSTEM_VARIABLE_TELLS_THE_OPTIMIZER_TO_SKIP_CERTAIN_PLANS_BASED_ON_ESTIMATES_OF_THE_NUMBER_OF_ROWS_ACCESSED_FOR_EACH_TABLE??$
sam?
Which of these comparisons is slowest?
Which statement is used to force the optimizer to use tables in a particular order?
Which statement is used to verify optimizer operation?
Reply to Comment
×
Name
*
Email
*
Comment
*
Submit Reply