Performance for select from view
There is a select from a view (for ekko, ekpo, ekbe tables) which taking long time, some times going to dump which trying to fetch 20,00,000 recirds from database view.
view has created because selects are taking long time.
Is there any way to fine tune.
Means which one either view takes long time of any other way to replace view select.