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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Performance

Status
Not open for further replies.
murli1200

murli1200

Technical User
Aug 18, 2006
3
US
if almost same amount of data is being loaded using bteq.. but sometimes it take 4 mins sometimes it take 90mins wat can be the reason
 
Sort by date Sort by votes
You need to be much more specific. Always the same time? Always the same table? What else is accessing TD during the load? Empty table or append? Where is the data coming from? LAN/WAN traffic?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

rdelloro
  • Locked
  • Question
TERADTA LEFT JOIN Increase performance
Replies
0
Views
29
rdelloro
rdelloro
cera18
  • Locked
  • Question
how do u improve the performance of a query 1
Replies
2
Views
49
cera18
cera18
murli1200
  • Locked
  • Question
performance
Replies
1
Views
44
RogerCruse
RogerCruse
zanzemaj
  • Locked
  • Question
Performance problem on Teradata SQL query
Replies
4
Views
101
zanzemaj
zanzemaj
CapsuleCorpJX
  • Locked
  • Question
Dyn SQL performance.
Replies
1
Views
51
dnoeth
dnoeth

Part and Inventory Search

Sponsor

Back
Top