Re: Slow performance on count(*)?
Date: Mon, 14 Jul 2008 17:53:54 -0700 (PDT)
It's interesting that "index full scan" is being used here, but it's quite possible.
This is not a degenerate case, actually very common and natural case. The simple fact is that delete never deallocates the free space. Only truncate or rebuild does it.
Dion Cho Received on Mon Jul 14 2008 - 19:53:54 CDT