Reply to Re: faster count(*) or alternative

Your name:

Reply:


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

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация