On Indexes and Commits

We're sitting here puzzling over this :)

Our developers use a table to store data during the execution of a report, they may end up inserting several to tens of thousands of records into this table to be reported on (of course this is a bad, but that's neither here nor there right now). The way the dev's are handling the records in this 'temp' table is to do no commit, and issue a rollback after the report is done - effectively cancelling the inserts. This allows multiple reports to run at the same time as each report only see's it's own sessions data.

My assertion is that doing things this effectively negates any indexes on the table. I don't see how they could be used w/out commiting the data. Is this true? Thanks. Received on Wed Aug 08 2001 - 16:33:56 CDT