Home » SQL & PL/SQL » SQL & PL/SQL » A doubt about loading rows
A doubt about loading rows [message #10661] Sun, 08 February 2004 20:56 Go to next message
Sudhakar
Messages: 34
Registered: May 2002
Member
I have created a table. There are thousands of rows to be inserted. I want the table to be indexed. Should the index be created before insertion of rows or after insertion of rows?

Report message to a moderator

Re: A doubt about loading rows [message #10671 is a reply to message #10661] Mon, 09 February 2004 01:45 Go to previous message
jigar
Messages: 74
Registered: July 2002
Member
It is recommended to build the index after bulk insertion.

Report message to a moderator

Previous Topic: ORA-1203
Next Topic: Record Count
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 18:10:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.