Doubt on Index and Analyze after importing a schema

From: Praveen <spraveen2001_at_yahoo.com>
Date: 17 Mar 2003 03:01:32 -0800
Message-ID: <98d8ec76.0303170301.48a2e6f6_at_posting.google.com>


Hi All,

I have a schema and i have created all necessary indexes and analyzed also.
when i export and import it into new schema. should i rebuild the indexes and analyze all the tables again? because after successfull import, if i see the last_analyzed of the tables and indexes, it is showing the date when i import the schema. Does it mean that if i import a schema to new schema, tables and indexes will automatically analyzed?

Thanks in Advance,
Praveen Received on Mon Mar 17 2003 - 12:01:32 CET

Original text of this message