Quicky : Views of views of views

Hello,

to make a report easier I'm developing it using a view of joined views of joined views.

Is there any significant performance penalty as opposed to just having one big select?

Cheers.

I think there is because running a view on more than one table need more processing power than running a view n a single table. So if you are concerned about performance issues, you might certainly not run a view of joined views of joined views. Try the big select rather. Hope it Helps...

Quicky : Views of views of views

Hello,

to make a report easier I'm developing it using a view of joined views of joined views.

Is there any significant performance penalty as opposed to just having one big select?

Cheers.

I think there is because running a view on more than one table need more processing power than running a view n a single table. So if you are concerned about performance issues, you might certainly not run a view of joined views of joined views. Try the big select rather. Hope it Helps...

Quick question on indexed views

Does moving a table (i.e. from Filegroup 'A' to filegroup 'B') that is part
of an indexed-view affect the indexed view at all?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200603/1
I feel it won't affect much
lutzdw wrote:
>Does moving a table (i.e. from Filegroup 'A' to filegroup 'B') that is part
>of an indexed-view affect the indexed view at all?
Message posted via http://www.droptable.com

Quick question on indexed views

Does moving a table (i.e. from Filegroup 'A' to filegroup 'B') that is part
of an indexed-view affect the indexed view at all?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1I feel it won't affect much
lutzdw wrote:
>Does moving a table (i.e. from Filegroup 'A' to filegroup 'B') that is part
>of an indexed-view affect the indexed view at all?
--
Message posted via http://www.sqlmonster.com

Quick question on indexed views

Does moving a table (i.e. from Filegroup 'A' to filegroup 'B') that is part
of an indexed-view affect the indexed view at all?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200603/1I feel it won't affect much
lutzdw wrote:
>Does moving a table (i.e. from Filegroup 'A' to filegroup 'B') that is part
>of an indexed-view affect the indexed view at all?
Message posted via http://www.droptable.com