Benchmark Test Data

CREATE TABLE RetailTable (
   Name VARCHAR(128) NOT NULL,
   ProductCategory VARCHAR(128) NOT NULL,
   Manufacturer VARCHAR(64) NOT NULL,
   MSRP Decimal(10,2) NOT NULL,
   OurPrice Decimal(10,2) NOT NULL,
   SalePrice Decimal(10,2),
   SaleStart Timestamp,
   SaleEnd Timestamp,
   SKU BigInt NOT NULL,
   UPC Decimal(12) NOT NULL,
   Quantity Integer NOT NULL,
   Description VARCHAR(512) NOT NULL,
   LongDescription Clob,
   ThumbnailPicture Blob NOT NULL,
   Picture Blob,
   OtherOffers VARCHAR(4000),
   RebateInfo VARCHAR(1024),
   UserRating Decimal(4,1) NOT NULL
)
 
CREATE INDEX Retail_Idx ON RetailTable (SKU)