Tuesday, March 20, 2012

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...

No comments:

Post a Comment