Hi skasarla,

I tried the composite index on tblline and the same, as I've just posted above the plan is the same as it was before.

All the fields I...

There is an index on site_fk in tblline.

I tried your query but it displayed the same execution plan as with my query. It uses the site_fk index to find...