2009-03-26 12:19:39.988 GMT Thread[main,5,main] (XID = 9621712), (SESSIONID = 0), select distinct cd_id from NCI_AUG00_1M where cd_molweight > 300 and cd_molweight < 320 ******* Project-Restrict ResultSet (3):
Number of opens = 1
Rows seen = 271136
Rows filtered = 0
restriction = false
projection = true
        constructor time (milliseconds) = 0
        open time (milliseconds) = 0
        next time (milliseconds) = 0
        close time (milliseconds) = 0
        restriction time (milliseconds) = 0
        projection time (milliseconds) = 0
        optimizer estimated row count:       203425.00
        optimizer estimated cost:       644900.84

Source result set:
        Index Row to Base Row ResultSet for NCI_AUG00_1M:
        Number of opens = 1
        Rows seen = 271136
        Columns accessed from heap = {0, 5}
                constructor time (milliseconds) = 0
                open time (milliseconds) = 0
                next time (milliseconds) = 0
                close time (milliseconds) = 0
                optimizer estimated row count:       203425.00
                optimizer estimated cost:       644900.84

                Index Scan ResultSet for NCI_AUG00_1M using index IDX_MOL_WEIGHT at read committed isolation level using instantaneous share row locking chosen by the optimizer
                Number of opens = 1
                Rows seen = 271136
                Rows filtered = 0
                Fetch Size = 16
                        constructor time (milliseconds) = 0
                        open time (milliseconds) = 0
                        next time (milliseconds) = 0
                        close time (milliseconds) = 0
                        next time in milliseconds/row = 0

                scan information: 
                        Bit set of columns fetched=All
                        Number of columns fetched=2
                        Number of deleted rows visited=0
                        Number of pages visited=1816
                        Number of rows qualified=271136
                        Number of rows visited=271137
                        Scan type=btree
                        Tree height=-1
                        start position: 
        > on first 1 column(s).
        Ordered null semantics on the following columns: 

                        stop position: 
        >= on first 1 column(s).
        Ordered null semantics on the following columns: 

                        qualifiers:
None
                        optimizer estimated row count:       203425.00
                        optimizer estimated cost:       644900.84