henrik staun poulsen (8/5/2010)

---

I'm looking for an explanation for some of the abreviations.

pk is Primary Key

ak is Unique Constraints ??

udx is Unique Index

idx is non unique index

"+" means that the field is an included field in the index

The numbers:

x.y

where x means the "index number" (what is this?)

and y means the Index Column ID

The sproc does a good job in showing the relationship between indexing and FK.

Thank you.

Best regards,

Henrik Staun Poulsen

http://www.stovi.com[/quote%5D

PK = Primary Key

AK = Alternate Key

UDX = Unique Index

IDX = Non-Unique Index

+ = Included column

x.y = Index#.Column#

I still use this before each release as a sanity check to spot redundant or missing indexes.