dbo.comex_importaciones

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 (~)	53674872
Created	6/1/2017 4:50:40 PM
Last Modified	8/23/2024 1:15:38 PM

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
2	cuit	varchar	50	0	0	False			False	False
	procedencia	varchar	50	0	0	False			False	False
	fobusd	varchar	50	0	0	False			False	False
	posicion	varchar	50	0	0	False			False	False
	fecha	varchar	10	0	0	False			False	False
	impo_id	int	4	10	0	True	1 - 1		False	False
	created	datetime	8	23	3	False		(getdate())	False	False

Indexes

Name	Columns	Unique
idx_comex_importaciones_cuit	cuit	False
idx_comex_importaciones_fecha_1	fecha	False
idxFobUSDFecha	cuit	False

SQL Script

Copy

CREATE TABLE dbo.comex_importaciones (
  cuit varchar(50) NULL,
  procedencia varchar(50) NULL,
  fobusd varchar(50) NULL,
  posicion varchar(50) NULL,
  fecha varchar(10) NULL,
  impo_id int IDENTITY,
  created datetime NULL DEFAULT (getdate())
)
ON [PRIMARY]
GO

CREATE INDEX idx_comex_importaciones_cuit
  ON dbo.comex_importaciones (cuit)
  INCLUDE (procedencia, fobusd, fecha)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idx_comex_importaciones_fecha_1
  ON dbo.comex_importaciones (fecha)
  INCLUDE (fobusd)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxFobUSDFecha
  ON dbo.comex_importaciones (cuit)
  INCLUDE (fobusd, posicion, fecha)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas