connect-session-knex
connect-session-knex copied to clipboard
MSSQL Schema Equivalents - Clustered/Non-Clustered?
Hello, I'm not completely familiar with PostgreSQL/SQLite nomenclature (i.e.: btree). I don't have an option to create a Clustered index for the Expired column.... can it be Non-Clustered?
Best I can glean from Microsoft's documentation is that both Clustered and Non-Clustered are considered "b-tree structures".
I've got the columns setup. I used datetimeoffset(7)
for Expired, if you think that's cool:
[sid] [varchar](255) NOT NULL,
[sess] [nvarchar](max) NOT NULL,
[expired] [datetimeoffset](7) NOT NULL,