cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
THEG72 Member
Member

What makes for a better index column?

Hi Support and Community,

 

What makes for a better unique key between fact and dimension tables as far as speed and compression go?

 

The UID or the ACCOUNT Number shown below in my chart of accounts?


The UID is a longer alphanumeric field and the account number is a fair bit smaller.. Both are text fields in the model.

 

Capturew.PNGWhich column should i index?

2 REPLIES 2
Super User II
Super User II

Re: What makes for a better index column?

Hi. I don't think you will found a significant difference. The short one may go faster. The best performance is with int values, but again I don't think you will notice so much difference in this case.

 

Regards,



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Proud to be a Super User!

LaDataWeb Blog


Highlighted
THEG72 Member
Member

Re: What makes for a better index column?

@ibarrau  thanks for your reply. Yes my understanding is text characters are slower than number/integer values. The account number however cant be resovled as a number due to the hyphen so it's formatted as text column like the uid.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors