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 5245Post New Intel PeopleSoft Administration Interview Questions
Whether you can create relational joins in tableau without creating a new table?
What are some candidates for the AES ?
What is transition in powerpoint?
How to Calculatea point using angles and distance?
What are the ways of backing up and restoring site collection?
What is validity fault?
What is Quality Score in Google AdWords?
Why do you not collapse under the pressure created by the atmosphere?
What does a star next to a powerpoint slide mean?
what function you write to do database testing with the help of qtp?
What is data type with example?
On android, a layout can contain other layout?
When columns are added to existing tables, what do they initially contain?
How do you supply construction arguments into a fragment?
How to move the one file from one instance to another instance? And your scripts also?