I have a program which is run on an ad-hoc basis....the database is mainly a read only dB, i.e. not much inserts/updates/deletes.
The process basically reads tables, then creates temporary oracle tables, creates indices on these tables and then does some inserts. The temporary oracle tables are then dropped when the process in run the next time round.
The performance has been good up until now but with much larger volumes of data it's slowing up.
Will bitmap indices help for querying the temp tables?
Do bitmaps take longer to create over b-tree?
PL/SQL functions set table column values when creating the table, should I remove them to table triggers?
Any other helpful ideas?
dB = 10g
Thanks in advance.