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

Report message to a moderator

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: 4963
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 22:39:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.