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
2672 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

HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?

4 Answers L&T,

i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance

2 Answers IBM,

What is the precedence of stage variables,derivations, and constraints?

0 Answers

How we can covert server job to a parallel job?

0 Answers

Describe the main features of datastage?

0 Answers

while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance

2 Answers MGL,

How can you find out whether datastage process is running or not in unix?

3 Answers Accenture,

how can we do null handling in sequential files

2 Answers Reliance,

how many types of remove the duplicate records?

3 Answers Caterpillar,

Hi , Today 1000 records updated, tomorrow 500 records updated how to find that?

4 Answers Wipro,

How to convert RGB Value to Hexadecimal values in datastage?

0 Answers

what is .dsx files

3 Answers IBM,

For more Data Stage Interview Questions Click Here