Re: Slow performance on count(*)?

From: Dion Cho <ukja.dion_at_gmail.com>
Date: Mon, 14 Jul 2008 17:53:54 -0700 (PDT)
Message-ID: <e707b981-0fa1-4533-8d91-6a49f4464016@z72g2000hsb.googlegroups.com>

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

This message: [ Message body ]
Next message: northof40: "Small scale - programmer driven - schema object/data restore"
Previous message: DA Morgan: "Re: Can Oracle Be Trusted With Your Data?"
In reply to: groups.broberg_at_gmail.com: "Re: Slow performance on count(*)?"
Next in thread: groups.broberg_at_gmail.com: "Re: Slow performance on count(*)?"
Reply: groups.broberg_at_gmail.com: "Re: Slow performance on count(*)?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message