[rt-users] Expensive Queries

Jeff Stark JStark at sumtotalsystems.com
Tue May 15 12:49:55 EDT 2007


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:jesse at bestpractical.com] 
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





More information about the rt-users mailing list