Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Insert in a table

This is a discussion on Insert in a table within the SQL forums, part of the Databases category; What is the best way to insert 100000 records in a table considering the performance issue. i mean data should be added in the table with least possible time....

Geeks Talk > Databases > SQL Insert in a table

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   01-29-2008

raj_imr2000 Junior Member   Join Date: Jan 2008 Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts

Insert in a table What is the best way to insert 100000 records in a table considering the performance issue. i mean data should be added in the table with least possible time.

Sponsored Links

#2 (permalink)   02-04-2008

debasisdas Moderator   Join Date: Jun 2007 Location: Bangalore,India Posts: 1,432 Thanks: 8 Thanked 125 Times in 112 Posts

Re: Insert in a table You need to use FORALL statement using PL/SQL.

#3 (permalink)   02-12-2008

expertsharingdotcom Junior Member   Join Date: Feb 2008 Posts: 11 Thanks: 0 Thanked 1 Time in 1 Post

Re: Insert in a table use the insert with select clause and also use the append hint which is used for direct path insertions. insert /*+ append */ into select ;

Geeks Talk > Databases > SQL

« Unique key and Single Query | Extract the table name by using its column name »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Insert new column in the middle of a table	Geek_Guest	SQL	19	09-22-2008 03:48 AM
insert picture to table	rashinkar	Oracle	7	05-28-2008 09:57 AM
Syntax to insert data in the table	Geek_Guest	Data Warehousing	6	09-18-2007 01:38 AM
Is it possible to insert a recode into fact table	Geek_Guest	Data Warehousing	1	09-04-2007 07:53 AM
How to insert data from one table to an empty table	sahanai mishra	Oracle Apps	1	08-11-2007 11:45 AM

All times are GMT -4. The time now is 07:34 PM.