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
Explain the disadvantages of a file processing system? Ans: Disadvantages of File Processing Systems include: 1) Data Redundancy 2) Data Inconsistency 3) Difficult to acce

Automated system for appointment with sms and call confirmation with service providers and user has to be initiate automatically. After selecting time and date to use service, s

What is first normal form? The domain of attribute must contain only atomic (simple, indivisible) values.

Explain CNT in the respects of QBE ? CNT: It is one of the aggregation commands given in QBE. It is used to identify number of tuples

The Proliferation of Object-Oriented Methods The first few years of the 1990s saw blossoming of around fifty various object oriented methods. This proliferation is a sign of g

Define a relation ? Relation - A relations is a named two-dimensional table of data. Mathematically, a relation can be described as a subset of the cartesian product of a lis

Define the Two Phase Locking Protocol This is a protocol that is used to make sure serializability of transactions. This protocol needs that every transaction issue lock and u

Compare three clustering algorithms in Weka. For this comparison, you will need to use at least two different datasets. Run the algorithms on the datasets, and use the visual

Example - ALTER TABLE emp MODIFY (empno NUMBER (7));

Which is the properties of entities? Attributes is the properties of entities.