I am trying to find out what type of indexing is used for historian tables in ms sql server heap or clustered index. My gut tells me clustered index but it has been wrong before. Ideally for the te table and the partition table — anyone out there know?
You should be able to answer this question yourself using SSMS (ms SQL server mgmt studio).
Right-click on the table you’re curious about and use the “Script Table as” feature to export the DDL statements (CREATE TABLE, etc).
