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
- 2605 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
Define repository tables in datastage?
which r the connectors used in san?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
Is it possible to query a hash file?
Is possible to create skid in dim,fact tables?
What are the different plug-ins stages used in your projects?
What is quality stage?
Can you explain repository tables in datastage?
Define meta stage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What is data partitioning?
What is process model?
How do you remove duplicate values in datastage?
How to RD using transformer?
