Thanks Ken and Jesse. We will continue to evaluate to see if we can find some performance gains in other ways.
-Stark -----Original Message----- From: Jesse Vincent [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 15, 2007 12:47 PM To: Kenneth Marshall Cc: Jeff Stark; rt-users Subject: Re: [rt-users] Expensive Queries On May 15, 2007, at 12:43 PM, Kenneth Marshall wrote: > Jeff, > > It sounds like you may need to make some more indexes. Please have > your DBAs provide a plan for the query execution. Look for sequential > scans in particular. That may help you identify possible index > creation options. We use PostgreSQL here, but I would suspect that > many of the index creations needed for it to be performant would be > the same with Oracle. Sadly, no. Every database really does want a different set of indexes. In particular, Oracle seems to strongly prefer single-column indexes. (And can use many of them on the same query.) The last time we saw test data with mysql and postgres, they dealt better with multi-column indexes. Best, Jesse _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users 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
