i have a little problem with the performance for an view and i don't know which solution is the best to get an higher performance.
The view has Sections from A to E.
Each section use different tables and different conditions and the section condition will expand in the future.
Whats the best way to get a better performance?
My idea is to save each section in tables and make a view with the data in the table.
Or does anyone have a better idea?