Your Onsite DBA has called you up and told you that one of
the tables PS_ABC_TAO has grown very big in size. Based on
the standard naming convention, you have determined that
the record is a temporary record since it ends with _TAOYou
look into the database and decide that that the data is not
required any more. You ask the DBA to delete the data in
the table.Next day you get a call from an irritated user
who says that a daily process that took only 1 minute to
run is taking about 2 hours today. You look into his
process and find that it uses PS_ABC_TAO as a temporary
table.What would you suggest the DBA to do ?
Answers were Sorted based on User's Feedback
Answer / avinash
Ask the DBA to update the Statistics for table PS_ABC_TAO .
Is This Answer Correct ? | 1 Yes | 0 No |
What is distributed managed server definition in weblogic server?
How can you change the jvm heap size?
what happens when changing from NO EDIT TO EDIT option?
Explain how to login into bs mode?
What are the uses of psstatus table?
Can you give example scenario for analytic server?
How do we start & stop peoplesoft webserver in single server domain?
Explain what event gets fired after db update?
Explain state records?
Differentiate between dddaudit and sysaudit?
Suppose you want to update your password and enter a hint for forgotten password. What would you access?
one particular query taking long time how to reduce that time