SELECT count(a.id) FROM books a WHERE a.kindid = 10;
Execution Plan
----------------------------------------------------------
0SELECT STATEMENT Optimizer=CHOOSE
10 SORT (AGGREGATE)
21 TABLE ACCESS (BY INDEX ROWID) OF 'BOOKS'
32 INDEX (RANGE SCAN) OF 'SYS_KINDID' (NON-UNIQUE)