Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1 Answers
- 2582 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / nikky
full table scane, no index will work
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you explain tagbatch restructure operator?
Why do we use link partitioner and link collector in datastage?
Define meta stage?
Does datastage support slowly changing dimensions ?
Difference between in process and inter process?
How to Remove Duplicate using SQL?
How to RD using transformer?
What is active and passive stage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What are routines in datastage? Enlist various types of routines.
What is the difference between server job and parallel jobs?
What is the project in datastage?
What can we do with datastage director?
How many areas for files does datastage have?
What all the types of jobs you developed?
