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
Define Serializable schedule Serializable schedule: An interleaved schedule of much more than one transaction is known as a serializable schedule, if it is equal to some serial

Two-way Associations Mostly, associations are travel in both directions, although not usually with same frequency. There are three approaches for the implementation. In

Define the five basic operators of relational algebra? Five basic operators of relational algebra are: 1. Union (∪∪∪∪) - Selects tuples which are in either P or Q or in both

What is a guard condition? Explain it with a suitable example. The guard-condition is a Boolean expression written with respect to parameters of triggering event and attributes

Question: (a) Use the following business rules to produce the E-R diagram. You should clearly show all the minimum and maximum cardinality constraint on each side of the relati

Scenario 1: Power goes out after the first instruction. What happens?

Define single valued and multivalued attributes. Single valued attributes: attributes with a single value for a particular entity are known as single valued attributes. Mult

Data Definition Language It organises the data in the form of columns and rows. But what does the data field column of table accumulate? How do you describe it using SQL? Th

What is the difference between SQL Server 2000 complete and differential backups? A complete backup makes a copy of the whole database. A differential backup creates a copy of

Create Student DB and perform delete operation? STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (section identifier, co