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
PGP.sig
Description: This is a digitally signed message part
_______________________________________________ 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
