[rt-users] Speeding up RT3

[Matthew Watson]

> 
> Now _that's's_ interesting. Have you ended up reindexing the Oracle
> database? If so, I know some folks who would love to see the work
> you've done. 

Find attached our current oracle indexes for RT3.

We also had to set 

optimizer_index_cost_adj = 30;

Otherwise the optimizer was passing up some of the indexes I believe.


Regards,
Matt.





This email and any files transmitted with it are confidential and intended solely for the 
use of the individual or entity to whom they are addressed. Please notify the sender 
immediately by email if you have received this email by mistake and delete this email 
from your system. Please note that any views or opinions presented in this email are solely
 those of the author and do not necessarily represent those of the organisation. 
Finally, the recipient should check this email and any attachments for the presence of 
viruses. The organisation accepts no liability for any damage caused by any virus 
transmitted by this email. 

-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: rt-indexes.txt
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20041005/be7e44a5/attachment.txt>