Files
indexer/services/db/migrations/021_output_idx.up.sql

3 lines
201 B
SQL

CREATE INDEX avm_outputs_chain_id_created_at ON `avm_outputs` (chain_id, created_at desc);
CREATE INDEX avm_outputs_chain_id_asset_id_created_at ON `avm_outputs` (chain_id, asset_id, created_at desc);