alter table table_name volatile cardinality so that the optimizer will consider using index scan rather than table scan. No matter how the statistics, the optimizer will use index scans instead of table scan. IBM also provided a document which REORGCHK this command, the table can be calculated according to statistics the need for restructuring. Example, the system can be divided into two parts, tables and user tables respectively REORGCHK: b2 reorgchk update statistics on table system b2 reorgchk update statistics on table user to note is that if a larger amount of data in the database, these operations a long time normally required, so the comparison in the database as far as possible free time to do. b2 update db cfg using AUTO_MAINT off AUTO_TBL_MAINT off AUTO_RUNSTATS off inside the database in DB2 8.2 can automatically collect statistical information, but this kind of action will bring additional load or, in general, the following can be turned off only when we need to run to it.
Although this can be seen as the language of praise, but the political thinking of entrepreneurs, leaders of both the professional standards of the formation and consolidation, but also lead to business people are likely to fall on the fate of emotional judgments and decision-making, is extremely dangerous. Chinese leadership, long-term conflict in the unorganized business ethics, this kind of ethic conflict, is also being applied to modern business management. That Chinese leaders and completely contrary to Western-style leadership is not accurate because the management of Chinese doctrine contains all modern management principles. But this likely to cause schizophrenia, management philosophy, management proposed for the high demands. He is equal time to prepare, with their left hand to pinch his right hand, the next step and become a clamp with his right hand his left hand. The idea of dualism, the most straightforward is the use of human resources, employment and the employer did not suspect to suspect, will happen in the same pair of leaders and subordinates, as the change with the seasons change. Between the different cases, and very difficult to extract the abstract of a suspect to no doubt to the suspect or not suspect the distinction between standards.