Two companies want to worship the words of "The Storm" as a teacher to teach martial arts heroes. Along the way they say opened. Company A: "I am without any foundation of enterprise information, or know how to learn, I heard within the FY line of heroes is an expert, have a strong Microsoft technical support, so I would like to study with a teacher heroes. "Business has been:" I know a little situation heroes, my friend is a teacher in the worship of the Masters, the areas of information in the enterprise is really save a lot of heart, ah, heroes of the moves easy to understand, as long as people will learn a computer could pick it. "said the two companies was on the mountainside in front of heroes to see the situation. The two companies quickly explained what he wanted, heroes said, "I have here a situation exclusive four-style nirvana, with the four-style, you canre putting enterprise information."
Note DB2/400 Chinese input problem in the string, in order to enter the Chinese language in the DB2/400 SQL to create this table, where the CCSID 935, on behalf of Simplified Chinese. And the same Oracle database, DB2 database, which is through the optimizer to analyze your SQL, build it that the best execution plan. DB2 optimizer is actually a standard set of rules, in general, as long as we tell DB2 what to retrieve, not how to retrieve. Then the DB2 optimizer to determine what SQL is based on the optimal access path? DB2 optimizer is cost-based optimizer, which is the CBO. That will be applied DB2 query optimizer cost formula, the formula for each possible access path to evaluate and weigh four factors: CPU cost, I / O cost, DB2 system catalog statistics and the actual SQL statement.