2012年2月26日星期日

Full Scans/Sec & Index Searches/Sec

What is consider good ratio for Full Scans/Sec to Index Searches/Sec?
I know you want the Full Scans/Sec as low as possible?
Thank You,
There is no good ratio that fits all situations. The more index you have,
the less full scan you need, but your updates become slower.
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joe K." <JoeK@.discussions.microsoft.com> wrote in message
news:B14B0CAD-F1AB-4587-BDF9-47196FA68A3B@.microsoft.com...
> What is consider good ratio for Full Scans/Sec to Index Searches/Sec?
> I know you want the Full Scans/Sec as low as possible?
> Thank You,

没有评论:

发表评论