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
2590 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 the use of DSattchJob?DetachJob? where can we find it?

0 Answers IBM,

SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS

1 Answers

Explain ibm infosphere information server and highlight its main features?

0 Answers

souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2

9 Answers

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

4 Answers TCS,

Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.

1 Answers CGI,

Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C

3 Answers Deloitte, IBM,

How To find the location of APT_confid file

2 Answers CTS,

Please tell me What is difference between 8.0 and 8.1

1 Answers IBM,

in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....

4 Answers

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

0 Answers IBM,

What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?

1 Answers

For more Data Stage Interview Questions Click Here