dbo.TE_tasa

Description

Properties

Name	Value
File Collation
File Group
Filestream File Group
Is Partitioned	False
Partitioned Column
Partition Scheme
File Groups
Filestream Partition Scheme
Filestream File Groups
Heap	True
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	4925013
Created	12/13/2017 3:50:38 PM
Last Modified	9/26/2018 4:58:31 PM

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Computed	Persisted
TEL_N	varchar	100	0	False		False	False
TLD	varchar	100	0	False		False	False
PRF	varchar	100	0	False		False	False
SFJ	varchar	100	0	False		False	False
NOMBRE	varchar	255	0	False		False	False
Calle	varchar	255	0	False		False	False
Nro	varchar	100	0	False		False	False
Piso	varchar	100	0	False		False	False
Depto	varchar	100	0	False		False	False
Unidad	varchar	100	0	False		False	False
Entrecalles1	varchar	100	0	False		False	False
Entrecalles2	varchar	100	0	False		False	False
Entrecalles3	varchar	100	0	False		False	False
Complemento	varchar	100	0	False		False	False
cd_postal	varchar	100	0	False		False	False
Localidad	varchar	100	0	False		False	False
Partido	varchar	100	0	False		False	False
Provincia	varchar	100	0	False		False	False
DOCU	varchar	100	0	False		False	False
CUITS	varchar	100	0	False		False	False
id_tasa	int	4	10	True	1 - 1	False	False
_domicilios_proc	tinyint	1	3	False		False	False
activo	tinyint	1	3	False		False	False

Indexes

Name	Columns	Unique
idx_activo	activo	False
idx_tasa_teln	TEL_N	False
idx_te_tasa_cuits	CUITS	False

SQL Script

Copy

CREATE TABLE dbo.TE_tasa_temp (
  TEL_N varchar(100) NULL,
  TLD varchar(100) NULL,
  PRF varchar(100) NULL,
  SFJ varchar(100) NULL,
  NOMBRE varchar(255) NULL,
  Calle varchar(255) NULL,
  Nro varchar(100) NULL,
  Piso varchar(100) NULL,
  Depto varchar(100) NULL,
  Unidad varchar(100) NULL,
  Entrecalles1 varchar(100) NULL,
  Entrecalles2 varchar(100) NULL,
  Entrecalles3 varchar(100) NULL,
  Complemento varchar(100) NULL,
  cd_postal varchar(100) NULL,
  Localidad varchar(100) NULL,
  Partido varchar(100) NULL,
  Provincia varchar(100) NULL,
  DOCU varchar(100) NULL,
  CUITS varchar(100) NULL,
  id_tasa int IDENTITY,
  _domicilios_proc tinyint NULL,
  activo tinyint NULL
)
ON [PRIMARY]
GO

CREATE INDEX idx_activo
  ON dbo.TE_tasa_temp (activo DESC)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idx_tasa_teln
  ON dbo.TE_tasa_temp (TEL_N)
  INCLUDE (TLD, PRF, SFJ, Calle, Nro, Localidad, Partido, Provincia)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idx_te_tasa_cuits
  ON dbo.TE_tasa_temp (CUITS)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas

dbo.TE_tasa_temp