Improves snowflake topology performance with oracle bench

[sergiobramil]

Direct Query loses a lot of performance when I have a cross-filter. I have an oracle based my fact table with 50 million records.

[v-qiuyu-msft]

Hi  @sergiobramil,

In my opinion, what you get is expected. The performance of the interaction in DirectQuery mode depends on the performance of the underlying data source. As all data is imported, large amount of data will cause lots of time to query. For more information, see: Important considerations when using DirectQuery.

Best Regards,
Qiuyun Yu

[sergiobramil]

Certainly the performance using direct query and smaller with respect to the imported base, but the question is not direct query with respect to the imported base, but the direct query with relationship with direction of the filter in both. When it matters the relationships comes filter dirreção in both, but in direct query comes all in single. Changing to both the performance is impractical in relation to the single.