On 5 Oct 2010, at 10:21, AI Rumman wrote:
> explain analyze
> select cf_1507
> from cf_1507
> inner join role2picklist on
> role2picklist.picklistvalueid=cf_1507.picklist_valueid
> where roleid!='H1' order by sortid
A few indexes on role2picklist.sortid and cf_1507.picklist_valueid would
pro
I am using two similar queries where one query is using index and other is
not.
I don't know why.
explain analyze
select ticketstatus
from ticketstatus
inner join role2picklist on
role2picklist.picklistvalueid=ticketstatus.picklist_valueid
where roleid!='H1' order by sortid
QUERY PLAN
--
