I am querying following sql statement as an OPS$USER.


SELECT DISTINCT id from SCOTT.USER_ID;

60Rows returned in 9Seconds.

But....

I queried same sql statement as an user SYS, it takes only .10 second to return.

This is on Sun Solaris 8 and Oracle 8.1.7.

SORT_AREA_SIZE = 960KB and this table has index.

Any idea why it takes much longer to get results if I run as an OPS$USER??????