gx0r/connect-session-knex

MSSQL Schema Equivalents - Clustered/Non-Clustered?

RayDeanTech opened this issue · 0 comments

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,

image