On Jan 30, 2006, at 12:23 PM, Alexander Hybel wrote:

  You might take a look at this message by Anthony Cartmell:

  http://sourceforge.net/forum/message.php?msg_id=2193013

  Some indexes are proposed to add a bit of performance.


  Some of the columns are already in an index.

  And  be  aware that any additional index might take noticeable extra

  space. But what's some extra space compared to good performance?


  At least this should give you a hint where to tune a bit.


Excellent link, Alexander, thank you. The difference is quite noticeable.

I do wonder: why are these indexes not created with the install? Just concerns about space with unwary users?