On Nov 30, 2007, at 2:31 PM, Kenneth Marshall wrote:
Here is a list of indexes that we use here. Check your schema
to see if you are missing any. You should not be getting a
sequential scan.
sequential scans are not automatically bad. if your result set is
more than a certain percentage of the whole table, it is more
efficient to scan the table than to do the extra disk seeks of going
back and forth to the index file too.
having too many indexes is bad, as you have just added a *lot* of
overhead for every insert/update/delete in that you must update all
the extra indexes.
there is some fine balance in between, which takes a lot of experience
and analysis to find.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:
If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch today.
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com