Oracle Reports: Temporary indexes?

From: John <john_at_austin.rr.com>
Date: Fri, 01 Mar 2002 00:49:11 GMT
Message-ID: <beAf8.30653$0y2.1618274_at_typhoon.austin.rr.com>

Anyone ever created "temporary" indexes using Oracle reports???

I need to create some indexes on some tables but b/c of the amount of inserts done on the table in the OLTP system, it is not feasible to create permanent indexes. I've never done this, but are there drawbacks to creating an index in the before report trigger, and then dropping the index in the after report trigger?

Thanks,
John Received on Fri Mar 01 2002 - 01:49:11 CET