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
- 2601 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
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What is the different type of jobs in datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
How many areas for files does datastage have?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
How we can covert server job to a parallel job?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What are the types of views in datastage director?
What all are the different way to run a job?
What is job control?
Give an idea of system variables.
What is the difference between odbc and drs stage?
How do you schedule or monitoring the job?
What are the some differences between 7.x and 8.x version of datastage?
how to sort two columns in single job in datastage.
