Types of indexes available in SQL Server 2019

• Evgeny Garaev

  SSCertifiable

  Points: 7428

  More actions

  April 27, 2021 at 12:00 am

  #3871117

  Comments posted to this topic are about the item Types of indexes available in SQL Server 2019

• Ant-Green

  SSC Guru

  Points: 113543

  More actions

  April 27, 2021 at 10:35 am

  #3876261

  Good question and well versed given the referenced link

  I said 13 as you can create indexes on persisted columns as referenced in a child document,  https://docs.microsoft.com/en-gb/sql/relational-databases/indexes/indexes-on-computed-columns?view=sql-server-ver15

• Jeff Moden

  SSC Guru

  Points: 1004596

  More actions

  April 27, 2021 at 3:52 pm

  #3876374

  Ant-Green wrote:

  Good question and well versed given the referenced link

  I said 13 as you can create indexes on persisted columns as referenced in a child document,  https://docs.microsoft.com/en-gb/sql/relational-databases/indexes/indexes-on-computed-columns?view=sql-server-ver15

  It's a real shame that and other MS documents don't actually cover the major problem with computed columns as Brent Ozar did in the following article, which also has a pretty good suggestion for a fix...

  https://www.brentozar.com/archive/2020/10/using-triggers-to-replace-scalar-udfs-on-computed-columns/

  --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)
  

• Jo Pattyn

  SSC-Dedicated

  Points: 32430

  More actions

  April 27, 2021 at 3:52 pm

  #3876375

  Thanks for the question. Learned about hash-indexes