use [dotcms_prod]
go

CREATE NONCLUSTERED INDEX [_dta_index_contentlet_10_1346103836__K4_K3_K43_K44_K45_2_5_6_7_8_9_10_11_12_14_15_16_17_18_19_20_21_22_23_24_25_26_27_28_29_30_] ON [dbo].[contentlet]
(
	[deleted] ASC,
	[working] ASC,
	[text1] ASC,
	[text2] ASC,
	[text3] ASC
)
INCLUDE ( [live],
[locked],
[show_on_menu],
[title],
[mod_date],
[mod_user],
[sort_order],
[friendly_name],
[language_id],
[last_review],
[next_review],
[review_interval],
[disabled_wysiwyg],
[date1],
[date2],
[date3],
[date4],
[date5],
[date6],
[date7],
[date8],
[date9],
[date10],
[date11],
[date12],
[date13],
[date14],
[date15],
[date16],
[date17],
[date18],
[date19],
[date20],
[date21],
[date22],
[date23],
[date24],
[date25],
[text4],
[text5],
[text6],
[text7],
[text8],
[text9],
[text10],
[text11],
[text12],
[text13],
[text14],
[text15],
[text16],
[text17],
[text18],
[text19],
[text20],
[text21],
[text22],
[text23],
[text24],
[text25],
[integer1],
[integer2],
[integer3],
[integer4],
[integer5],
[integer6],
[integer7],
[integer8],
[integer9],
[integer10],
[integer11],
[integer12],
[integer13],
[integer14],
[integer15],
[integer16],
[integer17],
[integer18],
[integer19],
[integer20],
[integer21],
[integer22],
[integer23],
[integer24],
[integer25],
[float1],
[float2],
[float3],
[float4],
[float5],
[float6],
[float7],
[float8],
[float9],
[float10],
[float11],
[float12],
[float13],
[float14],
[float15],
[float16],
[float17],
[float18],
[float19],
[float20],
[float21],
[float22],
[float23],
[float24],
[float25],
[bool1],
[bool2],
[bool3],
[bool4],
[bool5],
[bool6],
[bool7],
[bool8],
[bool9],
[bool10],
[bool11],
[bool12],
[bool13],
[bool14],
[bool15],
[bool16],
[bool17],
[bool18],
[bool19],
[bool20],
[bool21],
[bool22],
[bool23],
[bool24],
[bool25],
[inode],
[structure_inode],
[folder]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE STATISTICS [_dta_stat_1346103836_169_170] ON [dbo].[contentlet]([structure_inode], [folder])
go

CREATE STATISTICS [_dta_stat_1346103836_168_12] ON [dbo].[contentlet]([inode], [language_id])
go

CREATE STATISTICS [_dta_stat_1346103836_3_2] ON [dbo].[contentlet]([working], [live])
go

CREATE STATISTICS [_dta_stat_1346103836_2_12] ON [dbo].[contentlet]([live], [language_id])
go

CREATE STATISTICS [_dta_stat_1346103836_43_4_3] ON [dbo].[contentlet]([text1], [deleted], [working])
go

CREATE STATISTICS [_dta_stat_1346103836_2_168_12] ON [dbo].[contentlet]([live], [inode], [language_id])
go

CREATE STATISTICS [_dta_stat_1346103836_168_2_3] ON [dbo].[contentlet]([inode], [live], [working])
go

CREATE STATISTICS [_dta_stat_1346103836_3_12_168] ON [dbo].[contentlet]([working], [language_id], [inode])
go

CREATE STATISTICS [_dta_stat_1346103836_44_4_2] ON [dbo].[contentlet]([text2], [deleted], [live])
go

CREATE STATISTICS [_dta_stat_1346103836_168_169_170] ON [dbo].[contentlet]([inode], [structure_inode], [folder])
go

CREATE STATISTICS [_dta_stat_1346103836_44_4_3_43] ON [dbo].[contentlet]([text2], [deleted], [working], [text1])
go

CREATE STATISTICS [_dta_stat_1346103836_45_4_2_43] ON [dbo].[contentlet]([text3], [deleted], [live], [text1])
go

CREATE STATISTICS [_dta_stat_1346103836_4_2_43_44_45] ON [dbo].[contentlet]([deleted], [live], [text1], [text2], [text3])
go

CREATE STATISTICS [_dta_stat_1346103836_64_4_3_43_44] ON [dbo].[contentlet]([text22], [deleted], [working], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_47_4_2_43_44] ON [dbo].[contentlet]([text5], [deleted], [live], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_53_4_2_43_44] ON [dbo].[contentlet]([text11], [deleted], [live], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_58_4_2_43_44] ON [dbo].[contentlet]([text16], [deleted], [live], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_67_4_2_43_44] ON [dbo].[contentlet]([text25], [deleted], [live], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_57_4_2_43_44] ON [dbo].[contentlet]([text15], [deleted], [live], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_3_4_53_48_46] ON [dbo].[contentlet]([working], [deleted], [text11], [text6], [text4])
go

CREATE STATISTICS [_dta_stat_1346103836_50_4_2_43_44] ON [dbo].[contentlet]([text8], [deleted], [live], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_50_4_3_43_44] ON [dbo].[contentlet]([text8], [deleted], [working], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_64_4_2_43_44] ON [dbo].[contentlet]([text22], [deleted], [live], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_56_4_3_43_44] ON [dbo].[contentlet]([text14], [deleted], [working], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_62_4_3_43_44] ON [dbo].[contentlet]([text20], [deleted], [working], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_62_4_2_43_44] ON [dbo].[contentlet]([text20], [deleted], [live], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_56_4_2_43_44] ON [dbo].[contentlet]([text14], [deleted], [live], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_51_4_2_43_44] ON [dbo].[contentlet]([text9], [deleted], [live], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_63_4_2_43_44] ON [dbo].[contentlet]([text21], [deleted], [live], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_49_4_2_43_44] ON [dbo].[contentlet]([text7], [deleted], [live], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_61_4_2_43_44] ON [dbo].[contentlet]([text19], [deleted], [live], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_55_4_2_43_44] ON [dbo].[contentlet]([text13], [deleted], [live], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_51_4_3_43_44] ON [dbo].[contentlet]([text9], [deleted], [working], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_45_4_3_43_44] ON [dbo].[contentlet]([text3], [deleted], [working], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_58_4_3_43_44] ON [dbo].[contentlet]([text16], [deleted], [working], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_65_4_3_43_44] ON [dbo].[contentlet]([text23], [deleted], [working], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_59_4_2_43_44] ON [dbo].[contentlet]([text17], [deleted], [live], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_65_4_2_43_44] ON [dbo].[contentlet]([text23], [deleted], [live], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_55_4_3_43_44] ON [dbo].[contentlet]([text13], [deleted], [working], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_61_4_3_43_44] ON [dbo].[contentlet]([text19], [deleted], [working], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_49_4_3_43_44] ON [dbo].[contentlet]([text7], [deleted], [working], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_63_4_3_43_44] ON [dbo].[contentlet]([text21], [deleted], [working], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_2_4_53_48_46] ON [dbo].[contentlet]([live], [deleted], [text11], [text6], [text4])
go

CREATE STATISTICS [_dta_stat_1346103836_67_4_3_43_44] ON [dbo].[contentlet]([text25], [deleted], [working], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_48_4_3_43_44] ON [dbo].[contentlet]([text6], [deleted], [working], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_60_4_3_43_44] ON [dbo].[contentlet]([text18], [deleted], [working], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_47_4_3_43_44] ON [dbo].[contentlet]([text5], [deleted], [working], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_66_4_3_43_44] ON [dbo].[contentlet]([text24], [deleted], [working], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_57_4_3_43_44] ON [dbo].[contentlet]([text15], [deleted], [working], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_66_4_2_43_44] ON [dbo].[contentlet]([text24], [deleted], [live], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_52_4_2_43_44] ON [dbo].[contentlet]([text10], [deleted], [live], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_46_4_2_43_44] ON [dbo].[contentlet]([text4], [deleted], [live], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_54_4_3_43_44] ON [dbo].[contentlet]([text12], [deleted], [working], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_60_4_2_43_44] ON [dbo].[contentlet]([text18], [deleted], [live], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_48_4_2_43_44] ON [dbo].[contentlet]([text6], [deleted], [live], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_54_4_2_43_44] ON [dbo].[contentlet]([text12], [deleted], [live], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_52_4_3_43_44] ON [dbo].[contentlet]([text10], [deleted], [working], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_46_4_3_43_44] ON [dbo].[contentlet]([text4], [deleted], [working], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_53_4_3_43_44] ON [dbo].[contentlet]([text11], [deleted], [working], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_59_4_3_43_44] ON [dbo].[contentlet]([text17], [deleted], [working], [text1], [text2])
go

CREATE STATISTICS [_dta_stat_1346103836_168_4_3_43_44_45] ON [dbo].[contentlet]([inode], [deleted], [working], [text1], [text2], [text3])
go

CREATE STATISTICS [_dta_stat_1346103836_168_2_4_53_48_46] ON [dbo].[contentlet]([inode], [live], [deleted], [text11], [text6], [text4])
go

CREATE STATISTICS [_dta_stat_1346103836_168_4_2_43_44_45] ON [dbo].[contentlet]([inode], [deleted], [live], [text1], [text2], [text3])
go

CREATE STATISTICS [_dta_stat_1346103836_168_3_4_53_48_46] ON [dbo].[contentlet]([inode], [working], [deleted], [text11], [text6], [text4])
go

CREATE NONCLUSTERED INDEX [_dta_index_inode_10_478624748__K4_K6_2_3_7] ON [dbo].[inode]
(
	[type] ASC,
	[inode] ASC
)
INCLUDE ( [owner],
[idate],
[identifier]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go

CREATE STATISTICS [_dta_stat_478624748_6_4] ON [dbo].[inode]([inode], [type])
go

CREATE STATISTICS [_dta_stat_478624748_2_6] ON [dbo].[inode]([owner], [inode])
go

CREATE STATISTICS [_dta_stat_478624748_7_4] ON [dbo].[inode]([identifier], [type])
go

CREATE STATISTICS [_dta_stat_478624748_6_7_4] ON [dbo].[inode]([inode], [identifier], [type])
go

CREATE STATISTICS [_dta_stat_1074102867_16_3] ON [dbo].[template]([inode], [working])
go

CREATE STATISTICS [_dta_stat_1506104406_10] ON [dbo].[htmlpage]([sort_order])
go

CREATE STATISTICS [_dta_stat_1506104406_18_10] ON [dbo].[htmlpage]([inode], [sort_order])
go

CREATE STATISTICS [_dta_stat_1506104406_2_18] ON [dbo].[htmlpage]([live], [inode])
go

CREATE STATISTICS [_dta_stat_1506104406_3_4_18] ON [dbo].[htmlpage]([working], [deleted], [inode])
go

CREATE STATISTICS [_dta_stat_1506104406_6_2_4] ON [dbo].[htmlpage]([show_on_menu], [live], [deleted])
go

CREATE STATISTICS [_dta_stat_1506104406_3_18_8] ON [dbo].[htmlpage]([working], [inode], [mod_date])
go

CREATE STATISTICS [_dta_stat_1506104406_18_6_2_4] ON [dbo].[htmlpage]([inode], [show_on_menu], [live], [deleted])
go

CREATE STATISTICS [_dta_stat_1954106002_13_9] ON [dbo].[file_asset]([show_on_menu], [live])
go

CREATE STATISTICS [_dta_stat_1954106002_19_11] ON [dbo].[file_asset]([inode], [deleted])
go

CREATE STATISTICS [_dta_stat_1954106002_19_10_16] ON [dbo].[file_asset]([inode], [working], [mod_date])
go

CREATE STATISTICS [_dta_stat_1954106002_11_13_9] ON [dbo].[file_asset]([deleted], [show_on_menu], [live])
go

CREATE STATISTICS [_dta_stat_1954106002_19_13_9] ON [dbo].[file_asset]([inode], [show_on_menu], [live])
go

CREATE STATISTICS [_dta_stat_1954106002_10_11_19] ON [dbo].[file_asset]([working], [deleted], [inode])
go

CREATE STATISTICS [_dta_stat_1954106002_2_9_11] ON [dbo].[file_asset]([file_name], [live], [deleted])
go

CREATE STATISTICS [_dta_stat_1954106002_11_9_19_2] ON [dbo].[file_asset]([deleted], [live], [inode], [file_name])
go

CREATE STATISTICS [_dta_stat_1954106002_18_2_9_11] ON [dbo].[file_asset]([sort_order], [file_name], [live], [deleted])
go

CREATE STATISTICS [_dta_stat_1954106002_9_11_19_13] ON [dbo].[file_asset]([live], [deleted], [inode], [show_on_menu])
go

CREATE STATISTICS [_dta_stat_1954106002_19_9_11_18_2] ON [dbo].[file_asset]([inode], [live], [deleted], [sort_order], [file_name])
go

CREATE STATISTICS [_dta_stat_1634104862_5_4] ON [dbo].[identifier]([host_inode], [inode])
go

CREATE STATISTICS [_dta_stat_1634104862_4_2_5] ON [dbo].[identifier]([inode], [uri], [host_inode])
go

CREATE STATISTICS [_dta_stat_190623722_18_3] ON [dbo].[links]([inode], [working])
go

CREATE STATISTICS [_dta_stat_190623722_3_4_18] ON [dbo].[links]([working], [deleted], [inode])
go

CREATE STATISTICS [_dta_stat_190623722_18_6_2] ON [dbo].[links]([inode], [show_on_menu], [live])
go

CREATE STATISTICS [_dta_stat_190623722_6_2_4_18] ON [dbo].[links]([show_on_menu], [live], [deleted], [inode])
go

CREATE STATISTICS [_dta_stat_366624349_21_6] ON [dbo].[field]([structure_inode], [field_contentlet])
go

CREATE STATISTICS [_dta_stat_366624349_21_20] ON [dbo].[field]([structure_inode], [inode])
go

CREATE STATISTICS [_dta_stat_366624349_6_20] ON [dbo].[field]([field_contentlet], [inode])
go

CREATE STATISTICS [_dta_stat_366624349_6_21_20] ON [dbo].[field]([field_contentlet], [structure_inode], [inode])
go

CREATE STATISTICS [_dta_stat_1826105546_12_7_10] ON [dbo].[workflow_task]([inode], [belongs_to], [status])
go

CREATE STATISTICS [_dta_stat_1826105546_10_5_6] ON [dbo].[workflow_task]([status], [created_by], [assigned_to])
go

CREATE STATISTICS [_dta_stat_1826105546_5_6_7] ON [dbo].[workflow_task]([created_by], [assigned_to], [belongs_to])
go

CREATE STATISTICS [_dta_stat_1826105546_3_7_6_10] ON [dbo].[workflow_task]([mod_date], [belongs_to], [assigned_to], [status])
go

CREATE STATISTICS [_dta_stat_1826105546_3_5_7_10] ON [dbo].[workflow_task]([mod_date], [created_by], [belongs_to], [status])
go

CREATE STATISTICS [_dta_stat_1826105546_3_6_7_5] ON [dbo].[workflow_task]([mod_date], [assigned_to], [belongs_to], [created_by])
go

CREATE STATISTICS [_dta_stat_1826105546_12_10_5_6] ON [dbo].[workflow_task]([inode], [status], [created_by], [assigned_to])
go

CREATE STATISTICS [_dta_stat_1826105546_6_12_7_10] ON [dbo].[workflow_task]([assigned_to], [inode], [belongs_to], [status])
go

CREATE STATISTICS [_dta_stat_1826105546_12_5_6_7_3] ON [dbo].[workflow_task]([inode], [created_by], [assigned_to], [belongs_to], [mod_date])
go

CREATE STATISTICS [_dta_stat_946102411_4_5_6] ON [dbo].[tree]([tree_order], [child], [parent])
go

CREATE STATISTICS [_dta_stat_946102411_4_3_6] ON [dbo].[tree]([tree_order], [relation_type], [parent])
go

CREATE STATISTICS [_dta_stat_946102411_4_3_5] ON [dbo].[tree]([tree_order], [relation_type], [child])
go

CREATE STATISTICS [_dta_stat_946102411_5_3_6_4] ON [dbo].[tree]([child], [relation_type], [parent], [tree_order])
go

CREATE STATISTICS [_dta_stat_158623608_2] ON [dbo].[workflow_history]([creation_date])
go

CREATE STATISTICS [_dta_stat_158623608_5_2] ON [dbo].[workflow_history]([inode], [creation_date])
go

CREATE STATISTICS [_dta_stat_1474104292_4_2] ON [dbo].[category]([sort_order], [category_name])
go

CREATE STATISTICS [_dta_stat_1474104292_7_4_2] ON [dbo].[category]([inode], [sort_order], [category_name])
go

CREATE STATISTICS [_dta_stat_302624121_4] ON [dbo].[folder]([title])
go

CREATE STATISTICS [_dta_stat_302624121_2_6] ON [dbo].[folder]([name], [sort_order])
go

CREATE STATISTICS [_dta_stat_302624121_9_4] ON [dbo].[folder]([inode], [title])
go

CREATE STATISTICS [_dta_stat_302624121_3_9] ON [dbo].[folder]([path], [inode])
go

CREATE STATISTICS [_dta_stat_302624121_9_5] ON [dbo].[folder]([inode], [show_on_menu])
go

CREATE STATISTICS [_dta_stat_302624121_6_2_5] ON [dbo].[folder]([sort_order], [name], [show_on_menu])
go

CREATE STATISTICS [_dta_stat_302624121_9_2_6] ON [dbo].[folder]([inode], [name], [sort_order])
go

CREATE STATISTICS [_dta_stat_302624121_5_9_6_2] ON [dbo].[folder]([show_on_menu], [inode], [sort_order], [name])
go

CREATE STATISTICS [_dta_stat_1691153070_6_1] ON [dbo].[cms_role]([parent], [id])
go

CREATE STATISTICS [_dta_stat_1698105090_9] ON [dbo].[clickstream]([bot])
go

CREATE STATISTICS [_dta_stat_1698105090_2_1] ON [dbo].[clickstream]([cookie_id], [clickstream_id])
go