Feed on Posts or Comments

Tips & Tricks & Development REDBEARD0x0A on 18 Sep 2008 06:04 am

Sql Server Indexed Views

Nolvadex Faq Buy Nizoral Trenton Seroquel Forum Purchase Norvasc Juneau Where Order Tramadol Shipping Discount Nizoral United States Zithromax Testimonials Price For Hoodia Free Samples Sale Flomax Price For VPXL Cheapest Pills Buy Neurontin Jackson Where To Get Aldactone Shipping Herbal Prednisone United Kingdom Purchase Norvasc Tallahassee Herbal Stromectol Online Clinic Toprol XL Equivalent Prednisone Sale Aricept Buy Lasix Montpelier Where Order Avapro Overnight Delivery Generic Toprol XL Harrisburg Buy Inderal SantaFe Where Order Avapro High Doses Where Order Lotrisone High Doses Discount Amoxil Proper Dosage Lasix Shop Discount Plavix Prescription Price For Inderal Dosing Discount Lotrisone Free Samples Accutane Age Penisole Comparison Herbal Doxycycline Drug Information Buy Celexa Lansing Price For Ultram Comparison Discount Cipro Age Generic Lotrisone Cheapest Pills Order Female Viagra Salem Discount Neurontin France Buy Cipro Charleston Celexa Prescription Where Order Acomplia Italy Avapro Review Generic Aricept DesMoines Herbal Propecia Canadian Lexapro Where To Get Norvasc Canadian Where Order Zelnorm Description Price For Seroquel Drug Information Where To Get Lexapro RX Where Order Topamax United States

Microsoft SQL Server starting with version 2000 supports clustered and non-clustered indexes being added to views.  They are referred to as Indexed Views.

Such cases to use one:

  • Search Critera spans multiple tables
  • Speeding up queries that reference a view inside them

References:

http://www.microsoft.com/technet/prodtechnol/sql/2005/impprfiv.mspx

General performance:

http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1170220,00.html

Trackback This Post | Subscribe to the comments through RSS Feed

Leave a Reply