@Khalifa Mahgoub I am assuming the billion + row tables are fact tables. Just wondering if you are able to aggregate the tables to a higher granularity (although you may loss some of level of analysis if you aggregate too much but if that it's not an issue, maybe its an option you can consider)