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

WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?

1 Answers   Wipro,


In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

1 Answers   Wipro,


What are the two modes of datamovement in informatica sever?

2 Answers  


HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.

8 Answers   CTS,


any body can say about all versions of informatica ?how many versions ?

2 Answers  


What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers  


without using rank transformation how can we rank items by using some other transformations

2 Answers  


As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,


111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers   IBM,


What is a look up function? What is default transformation for the look up function?

2 Answers   ASM, TCS,


In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,


how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,


Categories