ble
after a certain length of time (i.e. 6 months).
So how large can a table be? As large as you want.
- Original Message -
From: "Ratheesh K J" <[EMAIL PROTECTED]>
To:
Sent: Thursday, August 03, 2006 2:42 AM
Subject: Table analysis - Help required urgently
Hello a
Ratheesh K J wrote:
Hello all,
I am required to analyze all the tables of our system. I need to know the key
parameters that should be taken into consideration for analysis. I am not speaking
about ANALYZE TABLE . I am required to manually look into all table
structures and pin point problems
If i was you i'd start reading the manual. Look under the optimization
chapter. Also, brush up on database normalization and look into how
exactly the tables are being used - run explains on the sql statements
that are used with the tables and see how you can optimize index usage.
Ratheesh K J
Hello all,
I am required to analyze all the tables of our system. I need to know the key
parameters that should be taken into consideration for analysis. I am not
speaking about ANALYZE TABLE . I am required to manually look into
all table structures and pin point problems ( if any ).
So it wo