-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Is there a way to analyze indexes to provide updated sizes? Is a vacuum the only way to determine the size of an index? Analyze updates the stats so I can see table space sizes but I cannot find an alternative to vacuum for indexes.
- -- - -------------------------------------------------- Jeremy M. Guthrie [EMAIL PROTECTED] Network Engineer Phone: 608-298-1061 Berbee Fax: 608-288-3007 5520 Research Park Drive NOC: 608-298-1102 Madison, WI 53711 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFAfsreqtjaBHGZBeURAm3+AJ9F34SESTf8i/oEuKvKfXoh+NcOxwCcDcM9 HP5LHM3Qidb4wa2/rW5H0cI= =mJCz -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match