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

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