Re: views

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Vinodk (vinodk_sct_at_NO_SPAM_hotmail.com)
Date: 04/20/04

  • Next message: izumi: "sql server performance" 
    Date: Tue, 20 Apr 2004 14:19:15 +0530

    >> I need to convince my client on this..

    Just look at the execution plan. You will find that the view has indeed used
    the base tables indexes for its execution. 

    -- 
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
<anonymous@discussions.microsoft.com> wrote in message
news:164601c4269c$1efa4b90$a001280a@phx.gbl...
> Thanks hari...I need to convince my client on this..also
> what are indexed views....is it equivalent to materilaized
> views in oracle.
> >-----Original Message-----
> >Hi,
> >Hi,
> >
> >No, the queries will use indexes if the views-- Base
> table have the
> >necessory indexes in place.
> >
> >Thanks
> >Hari
> >MCDBA
> >
> >
> >"sridhar" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:158f01c42697$9e087c90$a401280a@phx.gbl...
> >> in SQL2000, database views will not inherit the indexes
> >> of their underlying tables. So queries using indexes
> will
> >> be slow.  is it true?
> >
> >
> >.
> >
  • Next message: izumi: "sql server performance"

    Relevant Pages