Ab Initio Data Warehousing Question: How can you force the optimizer to use a particular index? Ab Initio Interview QuestionAnswer: Use hints /*+ <hint> */, these acts as directives to the optimizer Previous QuestionNext QuestionDescribe 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?
