Hi,

I have build a partitioned table with 193 milion rows and each partition has around 20million rows. If i analyze the table partition by partition and compute statistics, it gives ora-600 : [1113]
unable to exten temp segment in TS temp.
My temp ts is now 4 gig, i started it with 1G.

When increasing the temp TS didn't solve the problem then i did analyze with estimate statistics.

Is it Okey to work with estimate statistics instead of compute statistics.

Is compute statistics give more performance than estimate statitics ?.

What kind of index would give best performance on zip code (varchar2(5)) column in the above table ?.

Thanks in advance for help.

gtm