Re: ** statistics for zero row table - Yes or No?

From: Julio Aguilar-Chang <>
Date: Mon, 24 Aug 2009 08:48:19 -0600
Message-ID: <>

One other thing to consider if your table is over 1MB and zero rows: if this table is being used as an intermediate table for other processing, it looks as if the application, or user, is doing a "delete" instead of a "truncate" to clear the table. This in general is bad practice because a "delete" will not reset the high water mark, while a truncate will. Oracle will have to scan 1MB worth of blocks even if the table has zero rows, i.e. another performance hit on top of incorrect statistics.

> Going further what if the table size is over 1 MB and zero rows ?

Received on Mon Aug 24 2009 - 09:48:19 CDT

Original text of this message