Ways to suggest the dba, Database Management System

a)  Suppose we updated the catalog tables in real time, that is, after every update, insert, or delete SQL statement were executed-rather than only running RUNSTATS once every few days or longer.

Is this idea (real time updates), a good idea?   Provide arguments both for and against.

b)  Suppose the DBMS kept track of how long it took to execute each SQL statement:  i.e., for every single SELECT, INSERT, UPDATE, and DELETE statement.  Explain how the database system could use this information in some meaningful and practical ways to suggest to the DBA when it is time to reorganize the tables and indexes (or for the DBA to take other action). 

c)  When should a DBA consider dropping indexes from a table?  Give at least 3 good reasons.

Posted Date: 3/7/2013 4:42:05 AM | Location : United States







Related Discussions:- Ways to suggest the dba, Assignment Help, Ask Question on Ways to suggest the dba, Get Answer, Expert's Help, Ways to suggest the dba Discussions

Write discussion on Ways to suggest the dba
Your posts are moderated
Related Questions
a. Define the term "deadlock". There are four conditions that must hold before deadlock is possible. Name them. b. Outline an algorithm that detects whether there is a deadlock.

please give me introduction to full data in D B M S in a short assignment

The issues relating to the Design of the Physical Database Files Physical File is a file as stored on the disk. The major issues relating to physical files are:  •      Cons

What are the comparison operator in SQL?  Comparison operator in SQL are =, LIKE and BETWEEN

What is meant by heuristic optimisation?Discuss the major heuristics that are applied during query optimisation.

A super key is an attribute or set of attributes used to recognize the records uniquely in a relation. For instance, in the Relation PERSON defines earlier PERSON_ID is a super

With the help of a diagram defines the typical element modules of a DBMS? The functional elements of a database system can be widely divided into: 1) Storage manager and 2) q

Adding Redundant Associations for Efficient Access Redundant associations do not add any type of information, therefore during design we should actually examine structure of o

Explain the relevance of Data Dictionary in a Database System? Data dictionary is a database in its own right residing on the disk that consist of Meta data which is = Data abo

how to implement hyrise in C plus plus