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 is the difference between the .dbc and .cfg extensions and give any clear information ?

List the various vector functions used in ab initio with syntax.

What is local and formal parameter?

What is the difference between a DB config and a CFG file?

Have you used the rollup component? Describe how?

What is a partition?

what is the project environment(for each project the environment is same or different to different project)?

Explain what is the architecture of abinitio?

What are the primary keys and foreign keys?

what is decoding & what is NVL?

Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?

Can any body give me the clear explanation about how to separate header,trailer and body records in Ab Initio?

For more Ab Initio Interview Questions Click Here