Re: what happens to indexes when TRUNCATEing

["Willy-Bas Loos" <willybas@xxxxxxxxx>]

>> 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