Order By query Returns Different Rows (Doc ID 1947084.1)

Last updated on FEBRUARY 27, 2016

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.2.5.4 and later
Information in this document applies to any platform.

Goal

Why query would return different result set when the same query is used?

Query: with index
SELECT FIRST 1 column1 FROM table WHERE tableid=181667645  ORDER BY user_flag DESC;

returns:
< 114092573 >
1 row found.


Query: without index


SELECT FIRST 1 column1 FROM table WHERE tableid=181667645  ORDER BY user_flag DESC;
returns:
< 149313418 >
1 row found.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms