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

update statistics syntax

Status
Not open for further replies.
WiccaChic

WiccaChic

Technical User
Jan 21, 2004
179
US
When you update stats for multiple coluimns on the same table, does this syntax work:

update statistics high for table sometable (somefield1, somefield2, some field3)

Or do I need seperate commands for each field?
 
Status
Not open for further replies.

Similar threads

CPFB
  • Locked
  • Question
Update Query Asssitance Please
Replies
0
Views
151
CPFB
CPFB
cwbloucks
  • Locked
  • Question
Informix SQL Update using an inner join
Replies
0
Views
278
cwbloucks
cwbloucks
aft5425
  • Locked
  • Question
Update with Join Informix 4gl SQL
Replies
4
Views
332
PHV
PHV
manesv
  • Locked
  • Question
Update Informix Table through OpenQuery
Replies
0
Views
76
manesv
manesv
vlukes
  • Locked
  • Question
UPDATE & ?
Replies
2
Views
82
vlukes
vlukes

Part and Inventory Search

Sponsor

Back
Top