SQL Server Fun - 2

Suthish Nair

Suthish Nair

Feb 9 2011 5:23 AM

Lets have some another SQL query fun.  This only for learning purpose, anyone can reply with their inputs. Here we go..

I was working on my project and one of the requirement was to show product wise report.

The product master is from an external SQL DB. So, the process i followed.

1. Creating DBLink and fetching the records from master SQL DB through View.

2. Joining this View with my tables and showing the report.

3. Its takes around 8 - 10 secs to show the output for just 500 rows.

So my question is what happening here, why its takes this much time.
SELECT * FROM mytable
Which will run faster from above sql statement. How will i optimize my query.
Note: I already done this now the query run much faster, but needs some inputs from all you people. :)

Answers (5)