用分析函数就是全表+ORACLE优化的谓词推进，80w不至于效率太差，关键是你有多少个组，每个组返回多少条数据，共返回多少条数据，这很关键。 如果80w条，返回50w,那你要多快？1s??难啊 有个你80w返回几万条，到是可以优化，建立索引(no,sj) ...

Office mazes in which just about everybody below the rank of vice president works in large open spaces, divided by partitions into "cubicles," are the standard workplace setting for millions of ...