Re: GHOST ROWS ON TABLE PARTITIONED

From: Mladen Gogala <mgogala.SPAM_ME.NOT_at_verizon.net>
Date: Mon, 02 Apr 2007 03:35:11 GMT
Message-Id: <pan.2007.04.02.03.35.11@verizon.net>

On Fri, 30 Mar 2007 04:09:46 -0700, Andrea wrote:

> now i try to recreate table and reinsert rows...

What is the meaning of "recreate"? Do you mean "drop and create again"? Dropping table has a potential to damage statistics. That is April fools day way of putting it. Please, include re-calculation of statistics in the "recreate" procedure. Statistics comes to us by means of intelligunt desine and it needs an almighty hand to gather it after creating the table by "let there be table" statement.

-- 
http://www.mladen-gogala.com

Received on Sun Apr 01 2007 - 22:35:11 CDT