Skip to content

Instantly share code, notes, and snippets.

@bnsheehy
Last active December 6, 2021 03:05
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/e1e3ed23425d7d58b3033f6069c89d57 to your computer and use it in GitHub Desktop.
Save bnsheehy/e1e3ed23425d7d58b3033f6069c89d57 to your computer and use it in GitHub Desktop.
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