Introduction to Indexed Views in SQL Server

• Archana

  Old Hand

  Points: 332

  More actions

  February 25, 2020 at 12:00 am

  #3724703

  Comments posted to this topic are about the item Introduction to Indexed Views in SQL Server

• Jeff Moden

  SSC Guru

  Points: 1004600

  More actions

  February 25, 2020 at 2:47 pm

  #3728601

  This is a great introduction to Indexed Views, Archana.   It's well written, the order of revelation in the article is perfect, the example code is nice and simple and very nicely shows the advantages of Indexed Views, and the final example of how the original code benefited is a definitely a bonus.

  Thanks again for putting this together.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• Archana

  Old Hand

  Points: 332

  More actions

  February 25, 2020 at 6:00 pm

  #3728676

  Thank you, @jeff-moden.