查询优化解决“车站系统”数据库I/O冲突

Optimizing inquiring I/O of Oracle on Railway Station Information System

详细阐述优化查询SQL解决“铁路车站系统”数据库I/O冲突的步骤。“车站系统”中某些子系统响应速度非常慢,监视系统性能瓶颈时间段数据库的状态,比较两个以上时间点性能差异,发现引起性能瓶颈的主要问题来自I/O争用。可以通过建立索引,为查询增加参数,修连接改查询语句书写顺序等手段可以获得更加优秀的数据库查询计划。

It was expatiated the steps how to make the Oracle work well on select for us. After the example of optimizing The Railway Station Imformation System, we could get a conclusion that we could get work better execution plan by creating index,adding parameter to select statement,altering the order of the sql statement and creating temp table for large munber of data table.