• Hey pal,

    what do you mean by volatile rowid from the heap?

    Check a couple of posts upstairs, i pointed out the case of a full nulled row, but wasn't sure "why" count(*) included that kind of rows.

    Could it be just implementation desicion?

    Could the count(*) function get its return value from some sort of catalog when there is no where clause, instead of actually getting into the data?