All Downloads are FREE. Search and download functionalities are using the official Maven repository.

db.store.postgresql.V0_300_2__indexes.sql Maven / Gradle / Ivy

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




© 2015 - 2024 Weber Informatics LLC | Privacy Policy