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
- 1948 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
What are the main differences you have observed between 7.x and 8.x version of datastage?
How can you write parallel routines in datastage PX?
How to Remove Duplicate using SQL?
What are the differences between datastage and informatica?
Terminate Activity
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
why do u need the IOS upgradation in a FC switch
What are the areas of application?
What is the command line function to import and export the ds jobs?
how to abort the job its matain duplicates?
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.
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What are the functionalities of link partitioner?
What are the types of hashed files in data stage
How do you schedule or monitoring the job?
