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 Rhinorhino 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
Joined
Jan 21, 2004
Messages
179
Location
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 Question
Update Query Asssitance Please
Replies
0
Views
423
CPFB
CPFB
cwbloucks
  • Locked
  • Question Question
Informix SQL Update using an inner join
Replies
0
Views
690
cwbloucks
cwbloucks
aft5425
  • Locked
  • Question Question
Update with Join Informix 4gl SQL
Replies
4
Views
872
PHV
PHV
manesv
  • Locked
  • Question Question
Update Informix Table through OpenQuery
Replies
0
Views
174
manesv
manesv
vlukes
  • Locked
  • Question Question
UPDATE & ?
Replies
2
Views
246
vlukes
vlukes

Part and Inventory Search

Sponsor

Back
Top