Re: [sqlite] Table modifications and analyze

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,

[sqlite] Table modifications and analyze

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.