Improve lookup performance on da_datm_meta and da_loc_datm_meta tables

XMLWordPrintable

    • Type: Improvement
    • Resolution: Cannot Reproduce
    • Priority: Major
    • Component/s: DB
    • None

      The da_datm_meta and da_loc_datm_meta tables hold datum stream metadata, and are frequently referenced by queries that need to query datum streams, usually to look up stream IDs for a matching set of node/source ID combinations. There are no indexes on the table, but some might provide a query performance boost, for example in the node_id or loc_id columns.

            Assignee:
            Matt Magoffin
            Reporter:
            Matt Magoffin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: