On Sat, Mar 17, 2012 at 8:37 PM, Andy Chambers wrote:
> Hi All,
>
> If one drops an index inside a transaction, is that index still usable
> by other transactions? My use-case is loading millions of records
> into a heavily indexed table. I'd like to speed up the load by
> temporarily dropping t
On Sat, Mar 17, 2012 at 8:37 PM, Andy Chambers wrote:
> Hi All,
>
> If one drops an index inside a transaction, is that index still usable
> by other transactions? My use-case is loading millions of records
> into a heavily indexed table. I'd like to speed up the load by
> temporarily dropping t
Hi All,
If one drops an index inside a transaction, is that index still usable
by other transactions? My use-case is loading millions of records
into a heavily indexed table. I'd like to speed up the load by
temporarily dropping the indices. I'm wondering if I can do this
inside a transaction s