Hello, I'm sorry if this too basic. I searched the web but could not find an answer.
Q1: When you do a VACUUM ANALYZE does it update the statistics for existing indexes on the table? Or do you have to do an explicit REINDEX command on the index (or possibly drop and recreate the index)? thanks, Bill __________________________________ Do you Yahoo!? Vote for the stars of Yahoo!'s next ad campaign! http://advision.webevents.yahoo.com/yahoo/votelifeengine/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly