Home » SQL & PL/SQL » SQL & PL/SQL » Truncate
Truncate [message #195298] Wed, 27 September 2006 17:52 Go to next message
pradeepr
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: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
No.
Re: Truncate [message #195339 is a reply to message #195299] Thu, 28 September 2006 02:04 Go to previous message
JRowbottom
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: Fri Dec 09 17:14:26 CST 2016

Total time taken to generate the page: 0.20289 seconds