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
- 2519 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
explain about citrix scheduling tool in datastage
What are the functionalities of link partitioner and link collector?
How complex jobs are implemented in datstage to improve performance?
What is a merge?
How can one find bugs in job sequence?
What are the enhancements made in datastage 7.5 compare with 7.0?
What is difference between join, merge and lookup stage?
What a datastage macro?
Differentiate between Join, Merge and Lookup stage?
What is the differentiate between data file and descriptor file?
What are the different types of lookups in datastage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
what is the use of skid in reporting?
How many types of hash files are there?
