Skip to content

Instantly share code, notes, and snippets.

@bnsheehy

bnsheehy/Index_Columns.sql

Last active December 6, 2021 03:05
Show Gist options
  • Save bnsheehy/e1e3ed23425d7d58b3033f6069c89d57 to your computer and use it in GitHub Desktop.
Save bnsheehy/e1e3ed23425d7d58b3033f6069c89d57 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Index_Columns.sql
CREATE INDEX idx_ticker ON price_data_historical (ticker(8));
CREATE INDEX idx_figi ON price_data_historical (figi(14));
CREATE INDEX idx_date ON price_data_historical (date);
CREATE INDEX idx_update_date ON price_data_historical (last_update_date);
CREATE INDEX idx_corp_action_date ON price_data_historical (last_corp_action_date);
CREATE INDEX idx_key_id ON price_data_historical (key_id(30));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment