Auday Alwash wrote:
> 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 ***

"Madhivanan" <madhivanan2001@gmail.com> wrote in message
news:1132841546.627137.101470@g44g2000cwa.googlegroups.com...
> UNION ALL is more efficient that UNION as UNION will unnecessarily
> select Distinct and Order the data
>
> Madhivanan
>