Re: Need ideas for "proof test"

Interestingly when I repeat a slight variation on Dan's tests (test1 is identical selecting out col1, test2 selects out col4) I see a consistent, but negligible difference over repeated runs

Col1 with First: 1274
Col1 with Last: 984

PL/SQL procedure successfully completed.

• This was run one so the effect of disk reads is included.

Col4 with First: 728
Col4 with Last: 809

PL/SQL procedure successfully completed.

SQL> @ordered_data2
Col1 with First: 741
Col1 with Last: 797

PL/SQL procedure successfully completed.

Col4 with First: 752
Col4 with Last: 772

PL/SQL procedure successfully completed.

SQL> @ordered_data2
Col1 with First: 738
Col1 with Last: 759

PL/SQL procedure successfully completed.

Col4 with First: 722
Col4 with Last: 763

PL/SQL procedure successfully completed.

SQL> @ordered_data2
Col1 with First: 724
Col1 with Last: 754

PL/SQL procedure successfully completed.

Col4 with First: 735
Col4 with Last: 772

PL/SQL procedure successfully completed.

SQL> 9204 on winxp pro.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK