Re: Oracle Reports: Temporary indexes?

John wrote:
>
> 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

adhoc ddl is generally bad news. Maybe you could consider global temporary tables to extract the data and then report from that

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."