On Apr 14, 2008, at 2:49 PM, Petite Abeille wrote:
> Hello,
>
> What heuristics do people use to determine the frequency for analyzing
> their indices?
>
I use the simple heuristic of never running ANALYZE. The ANALYZE
command
is only helpful to the optimizer in certain extreme cases. See, th
Hello,
What heuristics do people use to determine the frequency for analyzing
their indices?
Is there something equivalent to user_tab_modifications that keep
tracks of the number of inserts, updates and deletes for each table?
Thanks in advance.
Kind regards,
--
PA.
http://alt.textdrive.c
2 matches
Mail list logo