Intrebari generalehttp://sqlserver.ro/forums/16/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)Re: indexed viewhttp://sqlserver.ro/forums/thread/278.aspxSat, 07 Oct 2006 18:18:44 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:278xmldeveloper0http://sqlserver.ro/forums/thread/278.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=278<P>Un exemplu concret gasiti aici:</P> <P><A href="http://msdn2.microsoft.com/en-us/library/ms191432.aspx">http://msdn2.microsoft.com/en-us/library/ms191432.aspx</A></P>Re: indexed viewhttp://sqlserver.ro/forums/thread/277.aspxSat, 07 Oct 2006 18:12:44 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:277SorinT0http://sqlserver.ro/forums/thread/277.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=277Cum se creaza un indexed view adica un exemplu in T-sql daca se poate m-ar ajuta.MultumescRe: indexed viewhttp://sqlserver.ro/forums/thread/231.aspxTue, 03 Oct 2006 06:57:45 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:231ggciubuc0http://sqlserver.ro/forums/thread/231.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=231Atentie cum alegeti vederile indexate, pentru ca acestea sunt actualizate automat pe masura ce in tabelele de baza intra date- aceasta atrage activitate suplimentara pe server!Re: indexed viewhttp://sqlserver.ro/forums/thread/227.aspxTue, 03 Oct 2006 06:32:34 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:227xmldeveloper0http://sqlserver.ro/forums/thread/227.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=227<P>Un view este un tabela virtuala sau cum mai spun unii un SELECT stocat.</P> <P>Indexed view inseamna ca tabela virtuala este materializata, adica pe scurt este stocata pe disc sub forma unui index.</P> <P>Pentru mai multe detalii puteti folosi urmatorul link: <A href="http://msdn2.microsoft.com/en-us/library/ms190426.aspx">Types of Views</A>&nbsp; </P>indexed viewhttp://sqlserver.ro/forums/thread/226.aspxMon, 02 Oct 2006 19:11:14 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:226SorinT0http://sqlserver.ro/forums/thread/226.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=226Ce este o indexed view, cum poate fi creata si cum o folosim?