1. What are optimizer hints? Give an example of their use.
2. What factors should you take into consideration when creating and using an index?
3. What does the database do differently between optimizing DDL vs DML statements?
4. List and describe 5 things that could cause a delay in query processing.

Answer rating: 100% (QA)

1 Optimizer Hints Optimizer hints are directives provided by the database developer or administrator to the query optimizer They are used to instruct ... View the full answer