Interested to Buy Any Domain ? << Click Here >> for more details...
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 ?
- 2 Answers
- 5341 Views
- Intel, I also Faced
- E-Mail Answers
Answer Posted / praveen
Update statistics on the table
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain state records. What is its purpose?
What is peoplesoft configuration manager?
Name the people tools available for integration broker?
How can you configure sql trace?
How do you uninstall the weblogic server?
Explain how many message nodes are possible for a database?
You want to upgrade a peoplesoft tool. How would you do it?
What are the valid values in peoplecode debugger?
Suppose I have created a menu and a page and given user access to that page, which of the tables gets affected on this?
Name a few third party tools / software required for ps to function.
What is distributed managed server definition in weblogic server?
How can you configure peoplecode trace?
What are the default values for psappsrv and other servers when application designer starts?
What elements are there in psadmin?
Explain what are the components which form the part of integration broker?
