Files
indexer/services/db/migrations/005_avm_transaction_index.up.sql
2020-09-28 07:05:47 -04:00

3 lines
161 B
SQL

CREATE INDEX avm_transactions_chain_id_created_at ON `avm_transactions` (chain_id, created_at desc);
DROP INDEX avm_transactions_chain_id ON `avm_transactions`;