db.store.postgresql.V0_300_2__indexes.sql Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of yaci-store-transaction Show documentation
Show all versions of yaci-store-transaction Show documentation
Yaci Store Transaction Module
The newest version!
CREATE INDEX idx_transaction_block
ON transaction(block);
CREATE INDEX idx_transaction_block_hash
ON transaction(block_hash);
-- transaction_witness
CREATE INDEX idx_transaction_witness_tx_hash
ON transaction_witness(tx_hash);
-- withdrawals
CREATE INDEX idx_withdrawal_address
ON withdrawal(address);
CREATE INDEX idx_withdrawal_tx_hash
ON withdrawal(tx_hash);