Thanks; I obviously missed something very essential there. RBS
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 30 December 2006 14:56 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Analyze before or after setting indices? "RB Smissaert" <[EMAIL PROTECTED]> wrote: > Doing some performance tweaking and wondering if there are any logical > reasons why it would be better to analyze a table before or after setting > the indices. I could figure it out by timing, but maybe somebody could tell > me already why one is better than the other. > > RBS The ANALYZE command examines indices, not the table itself. So you need to create your indices before running ANALYZE in order for it to do any good. -- D. Richard Hipp <[EMAIL PROTECTED]> ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------