• tt-615680 - Friday, February 23, 2018 4:03 AM

    I’m looking intocreating indexes and I want to know which types of indexes are better and inwhich situations to use them INCLUDE and COVERING?

     

     

    Thank you inadvance!

    Also, the INCLUDE clause in CREATE INDEX is one way of creating a covering index.  The other is to define all the columns as part of the index but then you are limited to either 16 columns or 900 bytes, which ever happens first.  As Sean said above, you really need to learn more about indexes.