Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Index and Insert

Status
Not open for further replies.
djj55

djj55

Programmer
Joined
Feb 6, 2006
Messages
1,761
Location
US
If I am inserting a few million records into a table, should I disable the indexes before then rebuild after?

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!
 
Sort by date Sort by votes
IMO yes :-)

Borislav Borissov
VFP9 SP2, SQL Server
 
Upvote 0 Downvote
Thank you.

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

WomanPro
  • Locked
  • Question Question
Insert into query adds records to unreadable format, how do I change that?
Replies
5
Views
812
Chris Miller
Chris Miller
peac3
  • Locked
  • Question Question
Gaps and islands
Replies
8
Views
893
Chris Miller
Chris Miller
peac3
  • Locked
  • Question Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
889
Andrzejek
Andrzejek
grnzbra
  • Locked
  • Question Question
Adding Text to and XML Field
Replies
2
Views
430
grnzbra
grnzbra
TheBugSlayer
  • Locked
  • Question Question
Transaction with SELECT and UPDATE with XLOCK causing deadlocks
Replies
10
Views
1K
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top