Before I send any table structures and sample SELECTs might someone knows my case as a general issue?
I have a table with stock quotes ca. 1M rows & 300 different companies. Then I have two views.
Fist selects latest stock quotes for some companies. The second selects stock quotes for 30 days ago for the same companies. Both views return 35 rows. And both run in ca. 200ms.
Then I have joined both views in the third view and this operation takes 1 minute. Join column is a nvarchar(100), so I understand it is not a perfect solution. But joining 35 rows with 35 rows cannot take so long. This can take almost same time in
Any ideas here?
View Complete Post