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 5251Post New Intel PeopleSoft Administration Interview Questions
What are the types of parameters in the function modules?
What is meant by decorator in angular?
how you can rehearse the slide show timing in powerpoint 2013?
How to how to convert numeric expression data types using the convert() function??
How do you flush privileges?
How do you print only part of a string?
I recently atten CSTB exam. One of the question is What is disadvantage of Static Analysis tool. Please help me find out answer
What is the difference between spufi and qmf?
What is __ main __ in python?
Why do power lines not short out when they fall into water?
Why might quick sort might be better than merge sort?
What is argument in excel?
Which processes require injection of radio isotopes in the body?
why ci and ca splits are not possible in esds and rrds?
What does pear stand for?