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
2608 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 many datamarts we will use in real time project and when will use the datamart?pls send the replay early

2 Answers Tech Mahindra,

What is staging variable?

0 Answers

How do you load dimension data and fact data? Which is first

2 Answers

why we use parameters instead of hard code in datastage

4 Answers HCL,

what is a message handler

3 Answers IBM,

Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.

6 Answers Teradata,

input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2

1 Answers HCL,

what are the types of nodes

4 Answers HCL, TCS,

How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?

3 Answers

Differentiate between validated and Compiled in the Datastage?

0 Answers

Hi Vijay here For Four CPU's how many nodes will required?

4 Answers TCS,

Difference between the Sequence and Sequencer in DS?

1 Answers TCS,

For more Data Stage Interview Questions Click Here