How can we eliminate source bottleneck using query hint

Interview Candidate
Jan 2nd, 2007
3
3354

Showing Answers 1 - 3 of 3 Answers

sreedhark26
Profile Answers by sreedhark26

Mar 12th, 2007

You can identify source bottlenecks by executing the read query directly against the source database.
Copy the read query directly from the session log. Execute the query against the source database with a query tool such as isql. On Windows, you can load the result of the query in a file. On UNIX systems, you can load the result of the query in /dev/null.
Measure the query execution time and the time it takes for the query to return the first row. If there is a long delay between the two time measurements, you can use an optimizer hint to eliminate the source bottleneck.