Re: Strange query result with Order by

Thanks a lot Mark !
i'll check that

Look at the plan with the "DESC" clause
i think you'r right !

Operation Object Name Rows Bytes Cost Object Node In/Out PStart PStop

SELECT STATEMENT Optimizer Mode=CHOOSE		2  	 	5  	 	      	             	 
  TABLE ACCESS BY INDEX ROWID	HIS_EVAL	2  	52  	5  	 	      	             	 
    INDEX SKIP SCAN DESCENDING	PK_HIS_EVAL	1  	 	4