>>>I would add an index on deleted too
>>>
>>
>>
>>Even after reading this http://fox.wikis.com/wc.dll?Wiki~NonDiscriminatingIndex ?
>
>On the same topic, but for SQL Server - an excellent read http://www.sqlskills.com/BLOGS/KIMBERLY/category/The-Tipping-Point.aspx


Good - but I won't read it today - been busy all day installing sqlserver 2008 + sp1 - with the necessary imagebackup and restore