在大型關(guān)系數(shù)據(jù)庫管理與開發(fā)中，優(yōu)化設(shè)計極大地提高數(shù)據(jù)庫的性能。通過對一大型數(shù)據(jù)庫查詢語句執(zhí)行過程的討論，提出了對同一表格進行多個選擇運算的優(yōu)化、多個表格的選擇運算的優(yōu)化、多個表格的聯(lián)結(jié)兼選擇運算的優(yōu)化、應(yīng)用窗口優(yōu)化和索引優(yōu)化設(shè)計方法，經(jīng)實際應(yīng)用驗證，其優(yōu)化過程簡便、有效，可達到減少計算量和內(nèi)存需求，提高了查詢響應(yīng)的速度，極大地改善數(shù)據(jù)庫性能，具有較強的實用性。
關(guān) 鍵 詞 關(guān)系數(shù)據(jù)庫; 查詢優(yōu)化; 窗口優(yōu)化; 索引優(yōu)化

Abstract In the management and development of large-scaled database, optimized design can improve its functions greatly. According to the discussion on performing query language of a large-scaled database, the authors propose an optimized design --- optimizing multi-choice operation on the same form, choice operation on multi-forms, connection & choice operation on multi-forms, the using window and index. In practical application, the process of optimization, which is simple and effective, can decrease the amount of counting and internal storage, can speed up query execution and performance and has a stronger usage.
Key words relational database; query optimization; window optimization; index optimization