-- YugabyteDb supports `IF NOT EXISTS` syntax when creating indexes.
-- If an index already exists with the same name, it will not be duplicated.
-- However, you should still review your pre-existing indexes in advance
-- to make sure you do not already have one or more of the same indexes
-- defined under a different name. If so, you should omit them
-- from what you apply to your YugabyteDb database.

CREATE INDEX IF NOT EXISTS idxalyswc028fb7oasa99jsk9fvc ON blc_order(account_id);
CREATE INDEX IF NOT EXISTS idxdwnptndx2usrj6jlvg2bejqe4 ON blc_order(root_account_id);