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!

how do u improve the performance of a query 1

Status
Not open for further replies.
cera18

cera18

Programmer
Joined
Feb 13, 2008
Messages
5
Location
US
hi friends
thanks in advance
cera
 
Sort by date Sort by votes
we can collect statistics on column or index,this is very useful while performing joins

syntax

collect statistics on<table name> column<column nmae>

collect statistics on <table name> index<column name(s)>
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Teamalone
  • Locked
  • Question Question
How to export multiple files using teradata tpt
Replies
0
Views
727
Teamalone
Teamalone
multipledatabases
  • Locked
  • Question Question
How to bulk import a CSV or a TXT file trough command into a Teradata database
Replies
1
Views
947
Miguel93
Miguel93
Janet Charbula
  • Locked
  • Question Question
Finding a value within a table
Replies
0
Views
536
Janet Charbula
Janet Charbula
Preshit
  • Locked
  • Question Question
Number of working days between two date fields
Replies
1
Views
669
johnherman
johnherman
tmcrouse
  • Locked
  • Question Question
tough time with a teradata date format
Replies
0
Views
537
tmcrouse
tmcrouse

Part and Inventory Search

Sponsor

Back
Top