Re: Analyze table
From: PaulCinVT <paulcinvt_at_aol.com>
Date: 23 Jun 1999 20:18:27 GMT
Message-ID: <19990623161827.08877.00001214_at_ngol07.aol.com>
Date: 23 Jun 1999 20:18:27 GMT
Message-ID: <19990623161827.08877.00001214_at_ngol07.aol.com>
In article <7jnipo$5fk$1_at_news.seed.net.tw>, "Todd" <toddlee_at_ms4.url.com.tw> writes:
>when we truncate a table and then insert new rows.
You need to re Analyze your table because TRUNCATE does not reset any of the
statistics...
Paul in VT
Received on Wed Jun 23 1999 - 22:18:27 CEST