I sort of have an example there that shows an index hint, the index hint being used, and the data - well - the data is sort of not sorted. Ok, let us say it even DOES follow your hint, did you, umm, well, read the order in the court link above? You might find it illustrative. Tell me - DOES ORACLE HAVE TO OBEY YOUR HINT. I win right?ĪRG, UGH, unbelievable - I just don't get the persistence people keep showing with such an obvious thing here. Therefore, coins when flipped will come up heads.
![recursive bookmark sorter does not sort by date recursive bookmark sorter does not sort by date](https://image.slidesharecdn.com/tailrecursion-170204170810/95/tail-recursion-4-638.jpg)
So, i flipped a coin and every time is comes up heads. | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time Ops$tkyte%ORA10GR2> select ename, sum(sal), grouping(ename) from emp group by rollup(ename) | Id | Operation | Name | Rows | Bytes | Cost (%CP Ops$tkyte%ORA10GR2> select /*+ parallel( emp 2 ) */ ename, sum(sal), grouping(ename) from emp group by rollup(ename)
![recursive bookmark sorter does not sort by date recursive bookmark sorter does not sort by date](https://beginnersbook.com/wp-content/uploads/2018/02/Python_Program_Find_Factorial_Of_Number-1024x781.jpg)
Ops$tkyte%ORA10GR2> set autotrace on explain Ops$tkyte%ORA10GR2> column PLAN_TABLE_OUTPUT format a72 truncate Ops$tkyte%ORA10GR2> create table emp as select * from scott.emp