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 5247Post New Intel PeopleSoft Administration Interview Questions
Sharepoint team services (sts)?
What is the function of consistency cqlsh command in Cassandra?
Hi all, I am using windows vista, I am in the process of learning QTP. When ever I try to work with insert mode in flight application , i am getting the error of 'Operation must use an update table query, fractional truncation(null) error. Can anyone help me regarding this?
What are the constraints on severity level in raiseerror?
Which command allows you to duplicate files?
What does connection pooling mean ?
As Derby is such a small DB, why do you prefer going for a Derby DB in a real-time project Implementation?
What is Ecology?
What can django do?
How do I change font in css?
What do you understand by hybrid cloud? Explain its advantages.
What is a hal error?
What is CorrelationToken in workflows and importance of it?
While setting owd (organization wide sharing), can we change/modify the setting of child record in case of master-detail relationship? : salesforce admin
Can we have multiple document.ready() function on the same page? : jquery mobile