Skip to content

Instantly share code, notes, and snippets.

@bnsheehy

bnsheehy/Index_PnF_Columns.sql

Created December 26, 2021 22:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bnsheehy/ab7dc3b435f4d003db52993b38b9b731 to your computer and use it in GitHub Desktop.
Save bnsheehy/ab7dc3b435f4d003db52993b38b9b731 to your computer and use it in GitHub Desktop.
Download ZIP
Index the PnF History Data Table Columns
Raw
Index_PnF_Columns.sql
CREATE INDEX idx_ticker ON base_pnf_data_historical (ticker(8));
CREATE INDEX idx_figi ON base_pnf_data_historical (figi(14));
CREATE INDEX idx_date ON base_pnf_data_historical (date);
CREATE INDEX idx_update_date ON base_pnf_data_historical (last_update_date);
CREATE INDEX idx_corp_action_date ON base_pnf_data_historical (last_corp_action_date);
CREATE INDEX idx_key_id ON base_pnf_data_historical (key_id(40));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment