niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » Sybase
how to query for table stats?
Post new topic   Reply to topic Page 1 of 1 [3 Posts] View previous topic :: View next topic
Author Message
bravegag
*nix forums beginner


Joined: 12 Apr 2006
Posts: 16

PostPosted: Fri Jun 23, 2006 1:12 pm    Post subject: how to query for table stats? Reply with quote
Hi all,

How to query Sybase for existence of stats on a table?

e.g. I have table A and I would like to know:

- whether it has stats computed.
- the date when they were computed.

Many thanks in advance,
Best Regards,
Giovanni
Back to top
Carl Kayser
*nix forums beginner


Joined: 25 May 2005
Posts: 42

PostPosted: Fri Jun 23, 2006 1:47 pm    Post subject: Re: how to query for table stats? Reply with quote
"bravegag" <bravegag@gmail.com> wrote in message
news:1151068340.185363.217640@r2g2000cwb.googlegroups.com...
Quote:
Hi all,

How to query Sybase for existence of stats on a table?

e.g. I have table A and I would like to know:

- whether it has stats computed.
- the date when they were computed.

Many thanks in advance,
Best Regards,
Giovanni


The info is stored in sysstatistics. In particular, moddate is (obviously)
the date of the statistics. Which statistics is not trivial since there
could index statistics, column statistics, partition statistics (and I might
have missed others). Use object_name (id) to determine the table name.

A useful article on Optimizer Mythology & Folklore, which covers statistics
issues, by Eric Miner is at ISUG, but this article is only
members-available.
Back to top
bravegag
*nix forums beginner


Joined: 12 Apr 2006
Posts: 16

PostPosted: Fri Jun 23, 2006 2:31 pm    Post subject: Re: how to query for table stats? Reply with quote
Carl Kayser wrote:
Quote:
The info is stored in sysstatistics. In particular, moddate is (obviously)
the date of the statistics. Which statistics is not trivial since there
could index statistics, column statistics, partition statistics (and I might
have missed others). Use object_name (id) to determine the table name.

A useful article on Optimizer Mythology & Folklore, which covers statistics
issues, by Eric Miner is at ISUG, but this article is only
members-available.

Thanks!!! you just saved my tomorrow saturday Smile


Best regards,
Giovanni
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [3 Posts] View previous topic :: View next topic
The time now is Tue Dec 02, 2008 2:56 pm | All times are GMT
navigation Forum index » Databases » Sybase
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Very slow query Michael Sutter MySQL 0 Fri Jul 21, 2006 1:10 pm
No new posts How to ALTER a table using the ALTOBJ procedure Serge Rielau IBM DB2 1 Fri Jul 21, 2006 1:06 pm
No new posts Can't Select External Table from CSV File Resant Server 1 Fri Jul 21, 2006 2:45 am
No new posts Column info without executing query Dan Strömberg PostgreSQL 10 Thu Jul 20, 2006 6:21 pm
No new posts recursive query Jürg Schaufelberger Server 1 Thu Jul 20, 2006 6:06 pm

Xbox Mod Chip | Loan | Cadillac | Myspace Layouts | Remortgages
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.1814s ][ Queries: 16 (0.1041s) ][ GZIP on - Debug on ]