Database DataWarehousing (MOSC)

MOSC Banner

oracel big parition table analyze question

edited Mar 23, 2010 3:24AM in Database DataWarehousing (MOSC) 5 commentsAnswered
our customer ask three quesiton , db is oracle 9i :

1.they have some big partition table , about 100 million  record  table ,

they said  they want to analyze this table, they find it cosumer a lot of time 5-6 hour ,

they want  to when meet this big partition table ,how to analyze it to save time ,

our colleague said thay just analyze 10% sample, i am not sure is that right or another method ?

2.and they did  analyze  table like that

analyze  table INF_IDLE_PROD_CONFIG compute statistics;

run about 5-6 hour ,and then they check user_table column num_rows ,it did't update ,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center