Hi All,
Shouldn't primary keys result in indexes and if so, shouldn't I be able to
see them when I list indexes?
Does inline index size applicable to primary keys too?
Additionally, when I do explain plan on a query which involves tables with
primary keys, shouldn't I see the primary key/index being used? Or lack of
a scan statement imply that an index is being used?
-------+
| PLAN |
+--------------------------------+
| SELECT
ID, NAME,TIMESTAMP
FROM PUBLIC.table1
/* PU |
sql is: select timestamp from table1 where id = 50 and name = 'John';
//primary key is on id + name
