October 24, 2013 at 2:25 am
Hello,
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?
October 24, 2013 at 2:31 am
I dont think you will get much help here unless you provide defintion of view along with index/table defintion.
please post them.
and by the way how did you find the perfoemance issue ? exec plan ? if yes post that too .
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 24, 2013 at 3:00 am
Indexed view
Malleswarareddy
I.T.Analyst
MCITP(70-451)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply