Home » SQL & PL/SQL » SQL & PL/SQL » Truncate
Truncate [message #195298] Wed, 27 September 2006 17:52 Go to next message
Messages: 1
Registered: September 2006
Junior Member
Does truncating a table delete the indexes for the table?

[Updated on: Wed, 27 September 2006 17:53]

Report message to a moderator

Re: Truncate [message #195299 is a reply to message #195298] Wed, 27 September 2006 18:13 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10673
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Re: Truncate [message #195339 is a reply to message #195299] Thu, 28 September 2006 02:04 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
It does delete the data from the indexes though.

Another very vague question.
Previous Topic: masiv Query Blocks on Statement
Next Topic: select in one line
Goto Forum:

Current Time: Sat Jul 29 06:49:20 CDT 2017

Total time taken to generate the page: 0.04038 seconds