Home » RDBMS Server » Server Administration » Creating an index on a table with data
Creating an index on a table with data [message #248933] Mon, 02 July 2007 14:52 Go to next message
Rustican
Messages: 51
Registered: July 2006
Member
Question about creating an index on a table that already has data in it. Will the previous rows in the table be indexed when i create the new index? If not how can i have the previous rows indexed?

Thanks.

I'm using Oracle 10g Enterprise Edition
Re: Creating an index on a table with data [message #248937 is a reply to message #248933] Mon, 02 July 2007 15:03 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Rustican wrote on Mon, 02 July 2007 15:52
Q Will the previous rows in the table be indexed when i create the new index?

yes. Depending on how many rows are in the table, it may take a long time.

[Updated on: Mon, 02 July 2007 15:03]

Report message to a moderator

Previous Topic: erorr Installing Oracle10g when ./runInstaller
Next Topic: How to add a new partition to an existing partition
Goto Forum:
  


Current Time: Sat Dec 03 07:47:04 CST 2016

Total time taken to generate the page: 0.12508 seconds