Part Columns of Table(Others Column is too relate with Cars Properties):

[CarId] [bigint] NOT NULL,

[BrandId] [int] NOT NULL,

[BrandChn] [nvarchar](50) NULL,

[BrandEng] [nvarchar](100) NULL,

[BrandOrigin] [nvarchar](50) NULL,

[MakeAssembly] [nvarchar](50) NULL,

[Make] [nvarchar](50) NULL,

[MakeShort] [nvarchar](50) NULL,

[SeriesId] [int]...

The Code is Writen by Previous Colleagues,I first Come to the Company.

Now Ready to Optimize.

I Have Asked Colleagues, They Said Many Columns of the Table is Used , in...