Index creation on large tables

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 Received on Wed May 12 1999 - 19:27:09 CDT