What are parallel querys and query hints?
Answer / nagaraju bhatraju
parallel queries to optimize query execution and index
operations for computers that have more than one
microprocessor (CPU). Because SQL Server can perform a
query or index operation in parallel by using several
operating system threads, the operation can be completed
quickly and efficiently.
| Is This Answer Correct ? | 6 Yes | 0 No |
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
What are the new features of informatica 9.x at the developer level?
when we go for unconnected lookup transformation? and why?
How the informatica server sorts the string values in Rank transformation?
What is a node in Informatica?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
how to import multiple flat files in to single target where there is no common column in the flat files
Explain lookup transformation is active in informatica
write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15
How to recover sessions in concurrent batches?
difference between top down(w.h inmon)and bottom up(ralph kimball)approach?
what transformations are used for Variable port?