Forum Discussion

binitafulpagare's avatar
binitafulpagare
Kudo Collector
1 month ago
Solved

What optimization techniques have given you the biggest performance improvements in Microsoft Fabric

Delta tables Partitioning Shortcuts Spark optimization Warehouse indexing Query optimization.
data science
  • v-achippa's avatar
    v-achippa
    1 month ago

    Hi binitafulpagare,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    There isn't a single optimization that provides the biggest improvement in every scenario, as it depends on the workload.

    However, in most Microsoft Fabric implementations, optimizing delta tables, proper partitioning and efficient query design, typically provide the most useful performance improvements. Spark tuning can further improve processing performance, while shortcuts mainly help reduce data duplication and simplify data management rather than directly improving query performance.

     

    Thanks and regards,

    Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Community Support
1 month ago

Hi binitafulpagare,

 

Thank you for reaching out to Microsoft Fabric Community.

 

There isn't a single optimization that provides the biggest improvement in every scenario, as it depends on the workload.

However, in most Microsoft Fabric implementations, optimizing delta tables, proper partitioning and efficient query design, typically provide the most useful performance improvements. Spark tuning can further improve processing performance, while shortcuts mainly help reduce data duplication and simplify data management rather than directly improving query performance.

 

Thanks and regards,

Anjan Kumar Chippa

  • v-achippa's avatar
    v-achippa
    Community Support
    1 month ago

    Hi binitafulpagare,

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

     

    Thanks and regards,

    Anjan Kumar Chippa

    • v-achippa's avatar
      v-achippa
      Community Support
      1 month ago

      Hi @binitafulpagare,

       

      We wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

       

      Thanks and regards,

      Anjan Kumar Chippa