Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query Relaxation Order

chris227Oct 31 2019 — edited Nov 8 2019

Hi,

In the 12.2 docs on oracle text in 4.1.15 Query Relaxation on oracle text the below is stated:

"Query hits are returned in this sequence with no duplication as long as the application needs results."

Usually the thumb of rule on ordering is always to use an order by (exception connect by e.g.).

Does the above quote mean that we don't have to use an order by since we will receive the rows implicitly in order of the searches defined?

And how will the order by defined for the row-outcome from the searches itselfs. Will it be on score?

And finally: will the DOMAIN_INDEX_SORT will have any effect without an order by?

Thanks in advance

Regards

Chris

This post has been answered by Roger Ford-Oracle on Oct 31 2019
Jump to Answer
Comments
Post Details
Added on Oct 31 2019
4 comments
297 views