Query binding:
A) Saves the access plan selected for a query
B) Reduces optimization time
C) May be changed if table profiles change
D) All of the above

Question

Quizplus · Accepted Answer

Query binding is a process of saving the access plan selected for a query, which helps in reducing optimization time. However, the access plan may need to be changed if table profiles change, which can be done using query rebinding. Therefore, all of the given choices are correct.

Query Binding