Re: Slow performance on count(*)?

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 15 Jul 2008 08:17:59 GMT
Message-ID: <487c5d37$0$1345$834e42db@reader.greatnowhere.com>

On Mon, 14 Jul 2008 10:29:09 -0700, groups.broberg wrote:

> Since when do tables with 0 rows require so much physical i/o to scan?

Look for "highwater mark" in oracle documentation.

-- 
Mladen Gogala
http://mgogala.freehostia.com

Received on Tue Jul 15 2008 - 03:17:59 CDT

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

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

Original text of this message