Additional Tutorials and Documentation
Space shortcuts
Space Tools

Versions Compared

Old Version 10

changes.mady.by.user Jeffrey Klann

Saved on

compared with

New Version 11

changes.mady.by.user Jeffrey Klann

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Tips for Optimizing i2b2 query speed

Postgres

  1. Do not use '%' in any concept code. In Postgres, this is known to prevent the database from using indexes.
  2. In Postgres, consider using table partitioning

MSSQL

  1. Use clustered columnstore indexes for the fact table.

All platforms

  1. If your fact table is extremely large, consider splitting it into multiple fact tables.
  2. ... more to come...