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 5242Post New Intel PeopleSoft Administration Interview Questions
what is the purpose of outline tab?
Define stored procedures.
Tell me is it safe to pay the premium through insurance agent? : insurance sales
How should you type cast a remote object? Why?
What is delimiter in c#?
How do I make all of my forms bootstrap opinionated?
What is the difference between angular and jquery?
What is the use of views in drupal 8?
What is the dual aspect concept?
What is ds heap sort?
Can we override static class in c#?
Explain MemStore?
What is the difference between catalog and content tab? : hana administration
how will you code the subfile which is in editing mode (multiple case subfile)?
what's prime importance of protection in electrical system.if protection system don't work properly what can happen in electrical system?