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 5152Post New Intel PeopleSoft Administration Interview Questions
What are the differences between twb and twbx?
What are different types of metrics in microstrategy?
What is hibernate in j2ee?
How to specify the sequence in which sub modules needs to be built?
Tailored Communication Style Describe an occasion when you have tailored your communication style to deal with a particular situation within your teamWhy was it necessary? What was the other persons role? What did you need to take
What keyword allows us to implement abstraction better in flex?
what is the purpose of using cyclhexane in synthesis?
Explain the accessibility modifier protected internal?
Is aws a cloud?
Explain android 4.0 library folder in android?
What are test driver and test stub and why we need them?
How to turn on the mssql api module in php?
What is a dc?
What is difference between safe mode and normal mode?
why we can use dust in concrete insted of fly ash