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 5339Post New Intel PeopleSoft Administration Interview Questions
In the phase when the cell is not dividing (interphase) is there activity within the cell nucleus?
What is meant by vector group
What are virtual machine scale sets in Azure?
Explain me what is general ledger account?
Why was the language called as Python?
What are the 3 logical operators?
Design a divide-by-3 sequential circuit with 50% duty circle now?
Explain what is fact less fact table? Where you have used it in your project?
can anyone explain me about retail domain project in informatica?
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
Explain the process to compute it?
What is redirectpermanent in asp.net?
why steel tanks are provided (a) for water pressure (b) for wind pressure (c) for earthquake pressure
How do you merge cells on word?
The magellan clouds are actually what type of celestial body?