ANALYZE [ VERBOSE ] [ table ] Notes: ANALYZE collects statistics about the contents of PostgreSQL tables, and stores the results in the system table pg_statistic. Subsequently, the query planner uses the statistics to help determine the most efficient execution plans for queries.
With no parameter, ANALYZE examines every table in the current database. With a parameter, ANALYZE examines only that table. It is further possible to give a list of column names, in which case only the statistics for those columns are updated. Notes It is a good idea to run ANALYZE periodically, or just after making major changes in the contents of a table. Accurate statistics will help the planner to choose the most appropriate query plan, and thereby improve the speed of query processing. A common strategy is to run VACUUM and ANALYZE once a day during a low-usage time of day. BR, N � ------------------------------------------------ On Tue, 28 Sep 2004 amitflu wrote : > >Hi, > >I need to determine "no.s of columns(fields)" of >a table using postgres sql. > >Thanks and Regards, >Amit > > > >__________________________________ >Do you Yahoo!? >New and Improved Yahoo! Mail - Send 10MB messages! >http://promotions.yahoo.com/new_mail > >_______________________________________________ >ilugd mailinglist -- [EMAIL PROTECTED] >http://frodo.hserus.net/mailman/listinfo/ilugd >Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi >http://www.mail-archive.com/[EMAIL PROTECTED]/ _______________________________________________ ilugd mailinglist -- [EMAIL PROTECTED] http://frodo.hserus.net/mailman/listinfo/ilugd Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/[EMAIL PROTECTED]/
