ALTER TABLE BLC_PRODUCT_TAG ADD VARIANT_ID VARCHAR2(36 CHAR);
CREATE INDEX IDXASL8YDC1H8R69PIETOSNNDES5 ON BLC_PRODUCT_TAG(VARIANT_ID, TAG_CONTEXT_ID);
CREATE INDEX IDXSOXNP92NIUAOF8G26TSYOSN2I ON BLC_PRODUCT_TAG(VARIANT_ID);
CREATE INDEX IDXT6AG1NXBL2TBCQHWR3D75FVLF ON BLC_PRODUCT_TAG(VARIANT_ID, PRODUCT_CONTEXT_ID);