Re: Index creation on large tables

cmilner wrote:

> Hi,
>
> Does anyone know the impact of creating an index while inserts are being applied to a table? I have a table with 50 million rows (partitioning soon!), but while I am recreating the index, a process is inserting rows to the table.
>
> I guess these newly inserted rows will not get included in the index, but will the only downside be when someone wishes to access data that is not held in the index, hence reducing access performance?
>
> Thanks for any help...
>
> Chris

--

Hi,

I have read in a computer magazine that Oracle 8i is able to insert rows while You create an index on the table. All releases of Oracle8 and older versions will lock the table while index creation is running.

Best Regards,

Ralph Ganszky

• The above opinions are mine and do not represent any official
• standpoints of my employer or third-party organizations.