Why might the optimizer use a table scan when an index is available?

Why might the optimizer use a table scan when an index is
available?

Question Posted / guest

No Answer is Posted For this Question
Be the First to Post Answer

More Ab Initio Interview Questions

what are kinds of layouts does ab initio supports ?

Can you read multiple input files using one input file component ? (Same DML) How to use in abinitio graph?

How do you improve the performance of a graph?

What a local lookup is?

Order of Evaluation of Parameters

Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?

What is MAX CORE of a component?

How can you connect eme to abinitio server?

What happens when we provide null key to sort, merge and pbks in Abinitio ?

State the relation between EME, GDE and Co-operating system?

What do you mean by the term data warehousing?

What are the benefits of data processing according to you?

For more Ab Initio Interview Questions Click Here