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 |
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
What are the two modes of datamovement in informatica sever?
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.
any body can say about all versions of informatica ?how many versions ?
What are the types of schemas we have in data warehouse and what are the difference between them?
without using rank transformation how can we rank items by using some other transformations
As union transformation gives UNION ALL output, how you will get the UNION output?
111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?
What is a look up function? What is default transformation for the look up function?
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
how to join the two flatfiles using the joiner t/r if there is no matching port?