Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DO or DONT Analyze SYS Objects ?
Andreas Wizemann doodled thusly:
>1) Do i need to use COMPUTE STATISTICS or should i use ESTIMATE (?
>rows or ? Percent)
up to you. if all workd well with estimate, then leave it. careful with some bugs with estimate that cause it to sample much less than 1/3 the table.
>
>2) What about Objects from user SYS ? Analyzing or not ?
>
no. never.
>Any Hints ?
use them in the SQL when all else fails.
Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam
Received on Sat Dec 29 2001 - 19:21:19 CST