Home » RDBMS Server » Performance Tuning » Efficient way to query and persist data. any leads
Efficient way to query and persist data. any leads [message #65270] Tue, 13 July 2004 18:14 Go to next message
RR
Messages: 19
Registered: October 2001
Junior Member
All,

I have a usecase whereby I need to query 15000 records and insert the same data under different identifier. For example the data is like

Name1
a
b
c

...to...

Name15000
x
y
z

This needs to be queried and peristed as

Test1
a
b
c
...to....

Test15000
x
y
z

at the end of the workflow the same table will have 30000 entries. Any ideas to do it efficiently rather than reading Name1 and Inserting Test1 as it is not efficient. There is one to one mapping between Name1 to Test1 , Name2 to Test2 and likewise

This is for Oracle 9i

Report message to a moderator

Re: Efficient way to query and persist data. any leads [message #65271 is a reply to message #65270] Wed, 14 July 2004 06:25 Go to previous message
Art Metzer
Messages: 2480
Registered: December 2002
Senior Member
Please do not cross-post.

Report message to a moderator

Previous Topic: URGENT: Backup of big table
Next Topic: Nested loop Vs Inlist iterator
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 23:31:29 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.