My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.