add necessary index
convert Decimal to float to avoid the following error:
TypeError: unsupported operand type(s) for *: 'Decimal' and 'float'
add necessary indices to original tables