Guidance on decorating table types with key details

[bgribaudo]

Hi,

Using Table.AddKey/Table.ReplaceKeys, it's possible to annotate the type returned by Table.View's GetType() handler with key information. To help us better understand when/what key information to provide, can you give us a sense for how Power Query uses this information?

In particular, I'm curious whether it's advantageous to decorate a table type with non-primary key information (e.g. to do Table.AddKey(..., ..., false). Does providing non-primary key info help influence the folding that M may attempt? Is it okay/helpful to set non-primary key details for non-unique keys or should its use be reserved only for unique non-primary keys?

Thanks, Ben