I have multiple aggregate tables created at different levels of aggregation grouped by smaller subset of keys. As an example-Table 1 : business_unit, account, balanceTable 2 : business_unit, balance When a query is written as select business_unit, balance from table1 where business_unit='mybu'; it would be faster to use table 2 instead but how do I substitute table 2 instead on table 1 in the query? Is there a way to add custom handlers either in the driver, optimizer or other points ? Any help or pointers will be appreciated. RK
Get Outlook for iOS