Truncate Table - What happens to indexes?

[Rahul Gupta <rg...@dekaresearch.com>]

What happens to indexes when a table is truncated?
Indexes are removed or they stay around?


Rahul Gupta
DEKA Research & Development<http://www.dekaresearch.com/>
340 Commercial St  Manchester, NH  03101
P: 603.666.3908 extn. 6504 | C: 603.718.9676

This e-mail and the information, including any attachments, it contains are intended to be a confidential communication only to the person or entity to whom it is addressed and may contain information that is privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender and destroy the original message.


________________________________
This e-mail and the information, including any attachments it contains, are intended to be a confidential communication only to the person or entity to whom it is addressed and may contain information that is privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender and destroy the original message.

Thank you.

Please consider the environment before printing this email.

Re: Truncate Table - What happens to indexes?

[Robert Coli <rc...@eventbrite.com>]

On Wed, Aug 19, 2015 at 11:05 AM, Rahul Gupta <rg...@dekaresearch.com>
wrote:

> What happens to indexes when a table is truncated?
>
> Indexes are removed or they stay around?
>

Secondary indexes are stored on disk in the same data directory as the data
and are truncated when the data they index is truncated.

=Rob