InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Explain The Purpose Of Optimizer Directives And How/why You Would Use Them |
|
Answer» A DBA can use DIRECTIVES MOSTLY to change / test / evaluate the execution plan (costs / benefits) for a QUERY, by FORCING an index / change JOIN order / etc. A DBA can use directives mostly to change / test / evaluate the execution plan (costs / benefits) for a query, by forcing an index / change join order / etc. |
|