What are parallel querys and query hints?



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

Post New Answer

More Informatica Interview Questions

Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,


Describe expression transformation?

0 Answers  


Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,


complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,


What is the use of code page?

0 Answers  






What is olap (on-line analytical processing?

0 Answers  


Can any one explain or sujjest some sites for scd mappings.Thank you

1 Answers   Wipro,


what is the difference between copy object import objects using repositery manager which one is best

1 Answers   TCS,


How to create a non-reusable instance of reusable transformations?

0 Answers   Informatica,


how to call lookup qualifer in unconnected look;up

1 Answers   BirlaSoft,


Name the different lookup cache(s)?

0 Answers  


What is the format of informatica objects in a repository?

0 Answers  


Categories