All tournaments for non logged in users

gistfile1.txt

/* All tournaments for non logged in users */


 EXPLAIN PLAN FOR
  SELECT * FROM (   
   SELECT rownum as rn, a.* FROM (
       SELECT * FROM Tournament t WHERE t.published = 1 AND t.closed = 0 AND t.cancelled = 0 AND t.submission_deadline >= '07/21/2015 10:30 AM' AND t.is_private = 0 ORDER BY submission_deadline ASC 
   ) a
) WHERE rownum <= 10 AND rn >  (1 - 1) * 10

===========OUTPUT=================

Plan hash value: 477096023
 
-------------------------------------------------------------------------------------
| Id  | Operation              | Name       | Rows  | Bytes | Cost (%CPU)| Time     |
-------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT       |            |     6 | 49596 |     8  (13)| 00:00:01 |
|*  1 |  COUNT STOPKEY         |            |       |       |            |          |
|*  2 |   VIEW                 |            |     6 | 49596 |     8  (13)| 00:00:01 |
|   3 |    COUNT               |            |       |       |            |          |
|   4 |     VIEW               |            |     6 | 49518 |     8  (13)| 00:00:01 |
|   5 |      SORT ORDER BY     |            |     6 |  2910 |     8  (13)| 00:00:01 |
|*  6 |       TABLE ACCESS FULL| TOURNAMENT |     6 |  2910 |     7   (0)| 00:00:01 |
-------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   1 - filter(ROWNUM<=10)
   2 - filter("RN">0)
   6 - filter("T"."PUBLISHED"=1 AND "T"."SUBMISSION_DEADLINE">=TO_TIMESTAMP('
              07/21/2015 10:30 AM') AND "T"."CANCELLED"=0 AND "T"."IS_PRIVATE"=0 AND 
              "T"."CLOSED"=0)