When I perform c3Count(TypeName), it takes an extraordinary long time when there are millions of records in the type object. Is there a way that this can be expedited?
By way of example: if I did a ‘select count ( * ) as recs from TABLE_NAME ‘ in Oracle, it would also take very long, but when I gave it a hint, as in
‘select /*+ ALL_ROWS */ count ( ‘a’ ) as recs from TABLE_NAME’, it would then alter the optimizer path and force it to find a unique index (preferably a PK index) and do a scan on the index using multi-block read-ahead and return the results in second, often sub-second.
Is there anything like this available for C3 so that we are not forced to watch the screen like animals at the zoo waiting to be fed?