ACD300 Web TestEngine demo

Review the following resultof an explain statement:

Which two conclusions can you draw from this?

Select all that apply.

• A

  The request is good enough to support a high volume of data. but could demonstrate some limitations if the developer queries information related to the product

• B

  The worst join isthe one between the table order_detail and order.

• C

  The join between the tables order_detail, order and customerneeds to be tine-tuned due to indices.

• D

  The join between the tables 0rder_detail and productneeds to be fine-tuned due to Indices

• E

  The worst join is the one between the table order_detail and customer