Table Index - ncidx__ST_STDNT_CLS_LOG

Properties

Property	Value
Name	ncidx__ST_STDNT_CLS_LOG_ETL
Index Key Type	None
Is Clustered	False
Is Full Text Key	False
Is Unique	False
Ignore Duplicate Keys	False
Fill Factor	0
Space Used (KB)	2861392
Is Index On Computed	False
Is Index On Table	True
No Automatic Recomputation	False
Filegroup	PRIMARY
Description

Columns

Name	Computed
EFF_TRM	False
REF_NUM	False
LOG_DATE	False
STDNT_ID	False
NOT_PAID_FLG	False
TRNSCTN_TY	False
LOG_TIME	False

Extended Properties

Object

Property

Value

DDL

/****** Object: Index [ncidx__ST_STDNT_CLS_LOG_ETL] Script Date: 03/09/2017 17:06:34 ******/
CREATE NONCLUSTERED INDEX [ncidx__ST_STDNT_CLS_LOG_ETL] ON [dbo].[ST_STDNT_CLS_LOG]
(
    [EFF_TRM] ASC,
    [REF_NUM] ASC,
    [LOG_DATE] ASC
)
INCLUDE ( [STDNT_ID],
[NOT_PAID_FLG],
[TRNSCTN_TY],
[LOG_TIME]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]