|
Posted by Greg D. Moore \(Strider\) on 02/26/07 14:47
"C10B" <tswalton@gmail.com> wrote in message
news:1172494748.828877.126110@m58g2000cwm.googlegroups.com...
> I'm still mildly puzzled as to how an indexed view would be quicker to
> function than going straight to the table. Surely there's exactly the
> same amount of work to be done?
> I'll check it out though and let you know if it's any quicker.
>
> Thanks
>
> Tim
>
If you want more help, I suggest you give us a complete DDL of your
database, some real example data and perhaps we can do better.
--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com
Navigation:
[Reply to this message]
|