Hi,
Can anyone help, how to know the type of indexes which were already created for the existing table, whether that is PRIMARY/UNIQUE/FULL-TEXT/SPATIAL/NON-CLUSTERED/SHARD.
When I am using INFORMATION_SCHEMA.STATISTICS table, I am able to see only 2 index_types i.e., BTREE,SHARD. Which ever index I will create the index_type showing as BTREE (storage structure).
Do we have any other information schema table/view to know these clear index information like in MSSQL DB.
Thanks,
kareemulla.dudekula@infor.com