user says the db performance is slow or yesterday the query runned 1min and today its taking 30 min. how to trouble shot or were to start with?
Answer / basanti
1. Check the volume of data.
2. check whether index need to be rebuild or not.
Is This Answer Correct ? | 1 Yes | 0 No |
what do u mean by canvases and alerts?
What is inner join in database?
What are the limitations of using a model?
What are the various Database states.
How to extract metadata for the entire database?
how to join two table?
What is built_in Subprogram ?
0 Answers BBAU Babasaheb Bhimrao Ambedkar University, HCL, TCS,
What are the different modes of mounting a Database with the Parallel Server ?
What is the use of COMPRESS option in EXP command ?
1. Difference between Lookup and join? 2. Difference between funnel and join? 3. What type of load you have used in your project? 4. What type of data warehouse schema you have fallowed in you project? 5. How many fact tables and dimension tables is their in project? 6. How do you kill the job process using windows environment? 7. Difference between sequence file and dataset? 8. What is delta load and subsequent load? 9. By using which stages you have implemented the SCD
Explain ERASE packaged procedure ?
Can the User set Archive file name formats ?