SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO



CREATE TABLE [dbo].[b](
	[id] bigint IDENTITY(-4611686018427387904,1) NOT NULL,
	[created_on] [datetime] NOT NULL,
	[v] [decimal](19, 2) NOT NULL,
	[start_date] [datetime] NOT NULL,
	[finish_date] [datetime] NOT NULL,
	[r] [decimal](19, 2) NOT NULL,
	[cq_id] bigint NULL,
	[ci_id] [dbo].[uID] NULL,
	[r_id] [dbo].[uID_guid] NULL,
	[pti] [int] NULL,
	[pd] [datetime] NULL,
	[d_date] [datetime] NULL,
	[sb_id] [dbo].[uID] NULL,
	[cm_id] [dbo].[uID_guid] NOT NULL,
	[cr_id] [dbo].[uID_guid] NOT NULL,
	[p_id] [dbo].[uID_guid] NULL,
	[oti] [char](1) NOT NULL,
 CONSTRAINT [pk] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
CREATE NONCLUSTERED INDEX [idx_cm_id] ON dbo.b
(
	[cm_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO
CREATE NONCLUSTERED INDEX [idx_cr_id] ON dbo.b
(
	[cr_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) 
GO
CREATE NONCLUSTERED INDEX [idx_cq_id] ON dbo.b
(
	[cq_id] ASC
)
INCLUDE ( 	[created_on],
	[v]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) 
GO
CREATE NONCLUSTERED INDEX [idx_ci_id] ON dbo.b
(
	[ci_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) 
GO
CREATE NONCLUSTERED INDEX [idx_finish_date_d_date] ON dbo.b
(
	[finish_date] ASC,
	[d_date] ASC
)
INCLUDE ( 	[cr_id],
	[oti],
	[r]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) 
GO
CREATE NONCLUSTERED INDEX [idx_oti_r_id] ON dbo.b
(
	[oti] ASC,
	[r_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) 
GO
CREATE NONCLUSTERED INDEX [idx_pti_p_id] ON dbo.b
(
	[pti] ASC,
	[p_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) 
GO
CREATE NONCLUSTERED INDEX [idx_r] ON dbo.b
(
	[r] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) 
GO
CREATE NONCLUSTERED INDEX [idx_sb_id] ON dbo.b
(
	[sb_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) 
GO
CREATE NONCLUSTERED INDEX [idx_start_date_pd] ON dbo.b
(
	[start_date] ASC,
	[pd] ASC
)
INCLUDE ( 	[cr_id],
	[v],
	[oti]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) 
GO

set ANSI_NULLS on
GO

set QUOTED_IDENTIFIER on
GO

create table dbo.t_internal (
	[id] [bigint] null
   ,[val] [decimal](19, 2) not null
   ,[spid] [smallint] not null,
   )
on [data]

GO


create clustered index [idx_t_internal_spid] on dbo.t_internal
(
[spid] asc
)with (pad_index = off, statistics_norecompute = on, sort_in_tempdb = off, drop_existing = off, online = off, allow_row_locks = on, allow_page_locks = off)
go


create view dbo.t
as
(
 select
   id
  ,val
 from
   dbo.t_internal t with (nolock)
 where
   t.spid = @@spid
)