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
- 2589 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
How do you register plug-ins?
What are stage variables and constants?
What are the types of containers in datastage?
What is the difference between in process and inter process?
What are the various kinds of containers available in datastage?
What is data partitioning?
What are the functionalities of link partitioner and link collector?
What are the different plug-ins stages used in your projects?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
How complex jobs are implemented in datstage to improve performance?
What is the project in datastage?
How do you schedule or monitoring the job?
What are the repository tables in datastage?
How can you write parallel routines in datastage PX?
Differentiate between Join, Merge and Lookup stage?
