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>
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