there are indexes on a table as index1 with col1, col2 index2 with col2 inde

there are indexes on a table as
index1 with col1, col2
index2 with col2
index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why

Question Posted / raj

1 Answers
2518 Views
Virtusa, I also Faced
E-Mail Answers

there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,co..

Answer / nikky

full table scane, no index will work

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Data Stage Interview Questions

What is a quality stage in datastage tool?

0 Answers

if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????

3 Answers

if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?

5 Answers Cap Gemini,

what is use of SDR function?

0 Answers CGI,

Unix command to view the data in a dataset

2 Answers IBM,

How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1 Answers Infosys, TCS,

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

0 Answers

What is the difference between Link collector and Funnel Stages?