Issues for database performance
Write down brief note on the issues for database performance?
Expert
The installation of the database is an imperative issue since the better the installation, the excellent the performance could be. Memory usage is learning how the DBMS employs main memory and then employing that knowledge to allow excellent performance. I/O is generally very intense in a DB, so understanding how users will employ the data will assist to prepare the database better. CPU usage and application tuning are as well important considerations.
What occurs while rows are determined using a FETCH statement?
Explain the drill mode?
Elucidate briefly power center repository?
What do you understand by the term denormalization and why would someone consider doing so?
Give a brief introduction of the term SAS Business Intelligence?
Specify the enhancements which are made within datastage 7.5 and also compare with the 7.0?
Explain all the types of Jobs you developed?
State the difference between the content store and content manager?
Explain terms Data Cache in Sybase. Answer: It is the memory area where data which is required for the current queries running is bought by Disk upon to memory for
Describe in brief some of the criticism regarding Sybase IQ?
18,76,764
1929264 Asked
3,689
Active Tutors
1421928
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!