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

Yaci Store Transaction Module

There is a newer version: 0.1.0-rc6

Show 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);