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
Explain db?
Explain how to upgrade valet to valet 2.0?
What is the role of Managed Metadata Service?
How do you perform annual closing in sap? : fi- general ledger accounting
Did anybody have method for acetyl cysteine effervescnce tablet
Explain about static nested classes in java?
Explain different types of index?
List the different types of print functions available in php?
Are you comfortable with cold-calling? : insurance cold calling
How can I do peek and poke in c?
What are the advantages of triggers?
what is c4x light weight cement blocks
What are mark complete and mark exception actions?
How is crm and r/3 differ from each other?
Which is more important for you: high salary or desired designation?