Database Administration (MOSC)

MOSC Banner

how to estimate consume TIME about DDL RUN TIME!

edited Mar 30, 2010 2:43AM in Database Administration (MOSC) 3 commentsAnswered
 our customer  have two quesiton ,they said they have a big table , 10 million rows ,

did select count(*)  form table  consume 30 second,

they want to kown  the consume  TIME  when did  two sql.

1.create  index  in this table , what time will consume?

2. modify column , did change one column from varchar2(20) to varchar2(500); what time  will consume?

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