Creating a temporary table with the option 'transactional' will now also create the indexes in transactional mode
