Need help with this query
UPDATE PPC_ADDRESS pa
SET pa.han_padded = LPAD(pa.han, 11, ' ')
WHERE pa.han IS NOT NULL
AND state
IN('AR', 'AZ', 'CA', 'CO', 'CT', 'DC', 'DE', 'GA', 'ID', 'IL', 'IN', 'LA', 'MA', 'MD', 'ME', 'MI', 'MN',
'NC', 'NH', 'NJ', 'NM', 'NV', 'NY', 'OH', 'OR', 'PA', 'RI', 'SC', 'TN', 'TX', 'UT', 'VA', 'VT', 'WA',
'WI', 'WY');
this statement is indexed on the han_padded column as a composite index - I've tried a function based index on the state column but its still running in an hour..
Does anyone have any idea on maybe a subselect that would whittle the time on this query?
WHERE pa.han IS NOT NULL
AND state
IN('AR', 'AZ', 'CA', 'CO', 'CT', 'DC', 'DE', 'GA', 'ID', 'IL', 'IN', 'LA', 'MA', 'MD', 'ME', 'MI', 'MN',
'NC', 'NH', 'NJ', 'NM', 'NV', 'NY', 'OH', 'OR', 'PA', 'RI', 'SC', 'TN', 'TX', 'UT', 'VA', 'VT', 'WA',
'WI', 'WY');
this statement is indexed on the han_padded column as a composite index - I've tried a function based index on the state column but its still running in an hour..
Does anyone have any idea on maybe a subselect that would whittle the time on this query?
0