Optimizing MERGE Performance using Liquid Clustering

Поделиться
HTML-код
  • Опубликовано: 1 фев 2025

Комментарии • 2

  • @Fernando-s4m1k
    @Fernando-s4m1k 4 месяца назад +3

    I disagree with clustering by the merge key. That only works for small tables. The merge key is your primary key for the table. You can't cluster by a PK because the cardinality is too high.

    • @2606matthew
      @2606matthew 4 месяца назад +4

      If the primary key is a business key and not randomly generated, it still makes sense to use. Cardinality doesn't matter with LC