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

What happens if the info. Server doesn't find the session parameter in the parameter file?

1 Answers  


What is workflow variable? When we use workflow variable? Can any one explain me with one example???

2 Answers   TCS,


what is Partitioning ? where we can use Partition?

2 Answers   IBM, TCS,


how can u tune u r informatica mapppings

2 Answers   CTS,


What are the challenges of Dataware housing in the future?

2 Answers   HP,






Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

8 Answers   HP,


What is meant by a domain?

0 Answers  


write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,


what is mapping override?

2 Answers   Cap Gemini,


what are the deliverables?in your project?

0 Answers   DELL,


why we use materialized view over view?

1 Answers   Zensar,


What is a data modeling?

2 Answers  


Categories