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
- 2673 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
Name the third party tools that can be used in datastage?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What is the difference between datastage and datastage tx?
How you Implemented SCD Type 1 & Type 2 in your project?
What is the difference between hashfile and sequential file?
Name the different sorting methods in datastage.
Define project in datastage?
What is the command line function to import and export the ds jobs?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
sed,awk,head
How do you remove duplicate values in datastage?
What is ds designer?
Can you explain repository tables in datastage?
how many rows sorted in sort stage by default in server jobs
What are the features of datastage flow designer?
