The query profile looks as below. If you would like to further tune the query, what is the best thing to do?

You ran a query and the query

SELECT * FROM inventory WHERE BIBNUMBER = 2805127;

The query profile looks as below. If you would like to further tune the query, what is the best thing to do?

A . Execute the below query to enable auto clustering
B. alter table inventory cluster by (BIBNUMBER);
C. Create an index on column BIBNUMBER
D. Divide the table into multiple smaller tables

View Answer

Answer: B

Explanation:

So this is again a question that is testing your working experience.

What do you see here?