- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Query Relaxation Order
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