SQL views

[SQLScholar]

Hey all,

I was having a conversation with a colleague who said he heard that accessing a table via view will increase performance as SQL holds the view in memory.

Now just to clarify - i am talking of a simple select * from table. No joins, no removed fields.

Is this correct? Does anyone have any information to prove/disprove?

I had never heard of this before, and thought it would be interesting to find out.

Many thanks

Dan

----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[onpnt]

I believe the only benefit in performance utilizing views is indexing the views themselves which in some cases will not help. I would venture to say if you have a view that is doing nothing more than a simple select off one table you will see no performance gains over hitting the table directly. At that point I would say security is your only benefit.

[sub]____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done[/sub]