考虑到您不需要一小时的时间，并且假设您正在尝试优化的是读取性能，以及一个优雅的模式：我建议为每个存储区增加7列，在每列上键入“bit”并带有过滤索引。
根据store表的页面大小和查询工作日的频率，您可能希望将store和business days放在两个不同的表中。

CREATE TABLE store (id INT PRIMARY KEY)
CREATE TABLE businessDays (
  store_id INT NOT NULL REFERENCES store(id),
  sunday bit DEFAULT 0, 
  monday bit DEFAULT 0,
  tuesday bit DEFAULT 0,
  wednesday bit DEFAULT 0,
  thursday bit DEFAULT 0,
  friday bit DEFAULT 0,
  saturday bit DEFAULT 0,
  INDEX ix_sunday (sunday) WHERE sunday = 1,
  INDEX ix_monday (monday) WHERE monday = 1,
  INDEX ix_tuesday (tuesday) WHERE tuesday = 1,
  INDEX ix_wednesday (wednesday) WHERE wednesday = 1,
  INDEX ix_thursday (thursday) WHERE thursday = 1,
  INDEX ix_friday (friday) WHERE friday = 1,
  INDEX ix_saturday (saturday) WHERE saturday = 1)

我希望这有帮助！如果您还有其他问题，请不要犹豫。：-）