What are parallel querys and query hints?
- 1 Answers
- 7626 Views
- I also Faced
- E-Mail Answers
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 |
Explain sessions. Explain how batches are used to combine executions?
what r the values tht r passed between informatics server and stored procedure?
What is Data Caches size?
write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010
What are the different types of Type2 dimension maping?
can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?
How to eliminate duplicate records in informatica mapping? Explain with an example....
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is the difference between procedure and stored procedur?
On which transformations you created partitions in your project?
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
Teradata 
