|
Posted by Auday Alwash on 11/24/05 05:14
Hi all,
SQL Server 2000 service pack 3 running on Quad zeon windows 2003 server
with 6GB of ram.
A few months ago we split our databases into operational and completed
data...
So now instead of doing select * from tblTest, we do select * from
tblTestboth where tblTestboth is a view like this:
Select *
From Operational.dbo.tbltest
UNION
Select *
From Archive.dbo.tbltest
The tables on both databases are heavily indexed but it still takes much
longer to do the select * from tblTestBoth than it is to do
Select *
From Operational.dbo.tbltest
UNION
Select *
From Archive.dbo.tbltest
Can anyone please tell me why that is? We are starting to get timeouts
regularly...
Should I use indexed views even though the data is inserted/updated
multiple hundres of times per second?
Thank you very much in advance for your help...
Regards,
Auday
*** Sent via Developersdex http://www.developersdex.com ***
Navigation:
[Reply to this message]
|