RE: [sqlite] Analyze before or after setting indices?

2006-12-30 Thread RB Smissaert
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" <[EM

Re: [sqlite] Analyze before or after setting indices?

2006-12-30 Thread drh
"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