Bissoy.com
Doctors Medicines MCQs Q&A

Which statement is used to force the optimizer to use tables in a particular order?

Which statement is used to force the optimizer to use tables in a particular order? Correct Answer STRAIGHT_JOIN

STRAIGHT_JOIN is used to force the optimizer to use tables in a particular order. The MySQL optimizer by default considers itself free to determine the order in which to scan tables most quickly.

Related Questions

Five tables T1, T2, T3, T4 and T5 are kept one above the other (Not necessarily in the same order) Number of tables above T4 are same as the number of tables below T5. T3 is just above T1. T5 is at the bottom. There are two tables between T2 and T5. Which of the following is the correct position of T1?
Three statements are given followed by four conclusions numbered I, II, III and IV. Assuming that the statements are true even if they seem to be at variance from commonly known facts, decide which of the conclusions logically follows from the statements. Statements: 1. All carpets are beds. 2. Some tables are carpets. 3. All pillows are tables. Conclusions: I. All pillows are beds. II. Some pillows are beds. III. Some beds are tables. IV. All tables are beds.
Statements : Some tables are TVs. Some TVs are radios.

Conclusions :
I. Some tables are radios.
II. Some radios are tables.
III. All radios are TVs.
IV. All TVs are tables.
Statements : Some tables are T.V. Some T.V. are radios.

Conclusions :
I. Some tables are radios.
II. Some radios are tables.
III. All the radios are T.V.
IV. All the T.V. are tables.
Ranjan purchased 120 tables at a price of Rs. 110 per table. He sold 30 tables at a profit of Rs. 12 per table and 75 tables at a profit of Rs. 14 per table. The remaining tables were sold at a loss of Rs. 7 per table. What is the average profit per table ?
Read the given statements and conclusions carefully. Assuming that the information given in the statement is/are completely true even if it seems to be at variance from commonly known facts, decide which of the given conclusion(s) logically follows from the statement. Statements: All chairs are tables. Some beds are chairs. All beds are furniture. Conclusions: I. All beds are tables. II. Some tables are furniture. III. Some chairs are furniture. IV. Some chairs are beds.
Consider the Assertion (A) and Reason (R) and select the correct answer:
Assertion (A) If one premise is particular, the conclusion must be particular.
Reason (R) (i) An affirmative particular has no distributed terms, and a negative particular has an only one.
(ii) The premises cannot both be particular and thus must differ in quantity.
Three statements are given followed by four conclusions numbered I, II, III and IV. Assuming that the given information is true even if it seems to be at variance from commonly known facts, state which of the given conclusions logically follows from the given statements. Statement: All boxes are tables. All tables are mats. All mats are chairs. Conclusion: I. Some chairs are boxes. II. All boxes are chairs. III. Some mats are boxes. IV. All tables are Boxes.
Consider the given statement to be true, even if they are at variance from commonly known facts, and decide which of the given conclusions can definitely be drawn from the given statements. Statements: 1. All tables are benches. 2. No benches are Almirahs. Conclusions: I. No tables are Almirahs. II. All benches are tables.
Read the given statements(s) and conclusions carefully and select which of the conclusions logically follow(s) from the statement(s). Statements: I. Some tables are wood. II. Some wood are brown. Conclusions: 1. Some brown are tables. 2. Some woods are tables.