How would you find out whether a sql query is using the indices you expect?

Question Posted / atul sahu

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

More Ab Initio Interview Questions

What are the Types of parallelism in detail?

What is meant header and tailer, suppose header and tailer had some junk data how will delete junk data ? which components r used?

Explain data flow graph with an example?

Describe which system or process elements you would review when trouble-shooting general server slows ?

You can ask about different vector functions. How to use in abinitio graph?

What is is a data flow graph?

What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?

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

Suppose we assign you a new project. What would be your initial point and the key steps that you follow?

Can anyone give me an exaple of realtime start script in the graph?

What will be the skew for, input file->partition by key-> partition by round robin->output file

) Diff.between Output index and Output indexes?

For more Ab Initio Interview Questions Click Here