Streaming delta table - Performance with incremental refresh

Fnazar
New Contributor II

Hi Team,

We are hitting performance issues with Streaming live delta table specifically when evaluating large tables of more than 10million rows. 
What are the workarounds to handle these streaming live tables in an attempt to load these large tables. 
Also, if we can use partition by then help me with the syntax please

Thanks