[rt-users] Slow Query w/ LimitCustomField RT 3.0.3Pre1

[Michael van Elst]

On Wed, Jun 04, 2003, Eric Liedtke wrote:

> explain SELECT DISTINCT main.* FROM ( Tickets main LEFT JOIN \
> TicketCustomFieldValues as TicketCustomFieldValues_1  ON \
> ((TicketCustomFieldValues_1.CustomField = '5')) AND (  main.id = \ \ \ \
> TicketCustomFieldValues_1.Ticket))  WHERE ((main.EffectiveId = main.id));

The table TicketCustomFieldValues is not indexed. Creating indexes
on the CustomField and Ticket columns might help.


-- 
    ,eM""=.            a"-.                         Michael van Elst
   dWWMWM" -          :GM==;                        mlelstv at dev.de.cw.net
  :WWMWMw=--.          "W='  cable & wireless
   9WWMm==-.
    "-Wmw-"  CABLE & WIRELESS