>> What happens to indexes on a table that is TRUNCATEd? >They are truncated too. >From the manual: "Furthermore, [truncate] reclaims disk space immediately, rather than requiring a subsequent VACUUM operation." Does this go for indexes too?
Thx, WBL -- "Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw