What are parallel querys and query hints?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

what is song in infrmatica...?

1913


What is informatica powercenter repository?

912


What is update strategy transform?

796


What are ETL Tools?

847


explain about unit testing? in real time?

1893


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1331


What are the main features of Oracle 8i with context to datawarehouse?

1863


Separate from an archive server and a powerhouse?

672


What are the types of caches in lookup?

770


What is the use of transformation?

760


What is session task and command task?

835


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1945


What is joiner transformation in informatica?

812


Slowly changing dimensions, types and where will you use them

1464


How to Create a folder using pmrep command?

830