Information_schema.index_statistics (INDEX_NAME)

[hyun.wee]

Hi,

I want to know the meaning of ‘INDEX_NAME’.
I created a table below. And I checked ‘information_schema.index_statistics’.

create table test (a int);

select * from information_schema.index_statistics;

Table do not have primary key, but ‘information_schema.index_statistic’ show PRIMARY.

Can you tell me the reason?

Thanks,

[adam]

Hi,

All rowstore tables in singlestore have primary keys. If the primary key isn’t user defined in the create table, then a hidden auto-increment column is added to be the primary key.

-Adam