Ab Initio Data Warehousing Question:

Download Job Interview Questions and Answers PDF

How can you force the optimizer to use a particular index?

Ab Initio Interview Question
Ab Initio Interview Question

Answer:

Use hints /*+ <hint> */, these acts as directives to the optimizer

Download Ab Initio Interview Questions And Answers PDF

Previous QuestionNext Question
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?What is a cursor? Within a cursor, how would you update fields on the row just fetched?