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 ***

[Back to original message]