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

How many parallelisms are in Abinitio?

How to run the graph without GDE?

When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?

wt is meant by repartioning in howmany ways it can be done.

Difference between informatica vs ab initio?

Mention what is abinitio?

Do you think effective communication is necessary for data processing?

Do you think effective communication is necessary for data processing? What is your strength in terms of same?

How you can create cross joined output using join component ?

What is conduct>it?

How can I run the 2 gui merge files?

How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on

For more Ab Initio Interview Questions Click Here