[rt-users] Expensive Queries

[Jesse Vincent]

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


-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070515/d1f46998/attachment.sig>