Hey thanks for that! 
I was hoping to optimize the speed and basically understand the "CORRECT" way of doing data processing.

We data process so millions ON THE SAME...

Thank you Jeff Moden. I just checked and confirmed that...

Yeah, it's quite weird. I just hope someone can shed some light on why that would be ?

I want to say I need to rebuild the table but...

So my query is :

SELECT
  OBJECT_NAME(A.[object_id]) as 'TableName',
  B.[name] as 'IndexName',
  A.[index_id],
  A.[page_count],
  A.[index_type_desc],
  A.[avg_fragmentation_in_percent],

Thanks for that. I will look into star schema. It does look like something that might be better for my type of work. I'm assuming it's because integer id's will...