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 4296Post New Intel PeopleSoft Administration Interview Questions
what is under coal gassification?
Why is this service branded with windows livetm?
How to require check-in comments?
What are the data types in sas?
What is pls integer?
How can javascript codes be hidden from old browsers that don't support javascript?
Mention what are the key features of solution manager diagnostics?
What type of records can be kept in a blockchain? Is there any restriction on the same?
How many columns can a mysql table have?
What is a collect statement?
what is specific fuel consumption,total fuel consumption,mean effective pressure,indicated thermal efficiency...
Explain equality operators in javascript?
What is the purpose of indexes?
what is a benifit to configure site to site vpn ?
Is go a case sensitive language?