Select * in a View

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Gerald Stowers (gerald.stowers.no.spam_at_re-move-me.execupay.com)
Date: 09/07/04 

Date: Tue, 7 Sep 2004 07:22:38 -0500

Hello,

I know using Select * in programming is a bad practice for performance,
but what about in a view? Is that a bad idea also?

We have an application that uses views for row-level security. Example,
I have a view of the invoice table to see only my invoices:

"create view users.invoices as select * from dbo.invoices where userid =
ME"

This makes updating the view easier since all I have to do is run
sp_refreshview to refresh the views, instead of changing the view code
each time table changes are made.

I understand that a definition of the columns the view accesses are
stored in a table to enable faster access plans, so does this make it ok
to use views with "Select *"

Thanks for any help!

Relevant Pages

  • Re: strlen(), K+1: clarification
    ... That's good practice. ... don't know programming in general. ... Computational complexity theory is not about ... condition tests an invariant: ...
    (comp.programming)
  • Re: "Sorting" assignment
    ... If you only learn the beautiful side of programming, ... but won't work in practice'", Kant replied to certain of his critics ... elegance and beauty from the fact that we developed this algorithm ... edumocational theory in which the students shall try, ...
    (comp.programming)
  • Re: XP and Pair Programming
    ... look at their idealism from a bsuiness management perspective. ... Over 25 years i've used the pair technique quite a bit. ... Its a 'usable' practice if I had two not-so-knowlegeable people ... when you work out paired programming on a balance ...
    (comp.object)
  • Re: How to write a check
    ... English and American practice in having intersentence spaces a third ... Computer Programming_ ... copy" and even publishing houses are using off-the-shelf word ... in physics who don't know TeX or LaTeX. ...
    (alt.usage.english)
  • Re: Quality assurance for CNC programs - Help needed.
    ... someone's programming and with the way MTB's set up the machine/control. ... They are hired to design a machine tool, ... is unacceptable practice regardless of ... language - just as failure to take appropriate action when such errors ...
    (alt.machines.cnc)