Re: TRUNCATE v DROP TABLE question

From: Jeff Kish <jeff.kish_at_ait-mmii.com>
Date: Mon, 28 Jan 2002 09:29:40 -0500
Message-ID: <51oa5uk2s6dqlsgon4dq30ao0nuvtremlt_at_4ax.com>

Greetings.
Shouldn't you rebuild your indices, since the data probably changed a whole lot, or is that done via the disable/enable?

Thanks
Jeff
p.s. a bit of a rookie here ;)

On Thu, 24 Jan 2002 19:17:05 GMT, "nandeep" <nandeep_at_hotmail.com> wrote:

>
>I would Disable the indexes and then re-enable them
Received on Mon Jan 28 2002 - 15:29:40 CET

This message: [ Message body ]
Next message: Geoffrey: "PS/SQL Procedure (Error)"
Previous message: Helen: "How to go to next Excel Worksheet from Oracle Forms using DDE?"
Maybe in reply to: harry: "TRUNCATE v DROP TABLE question"
In reply to nandeep: "Re: TRUNCATE v DROP TABLE question"
Next in thread: Geoffrey: "PS/SQL Procedure (Error)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message