hello all

i have view on live database take big time
and i dont have other ideas to solve it

it consist of two tables
and they are joined right
and i make analyze the two tables and it not worked


plz help me
thanks