阅读背景:

如何使用多个可搜索列有效地搜索MySQL数据库?

来源:互联网 

I have a table with 60 boolean (TINYINT(1)) searcheable columns. User has possibility of using any subset of the given columns as search condition. Based on that I cannot create a good index for my needs. I was wondering if I can create another column (concat_col) of type BIT(60) that would be concatenation of the searchable columns, i.e.I have a table with 60 boolean (TINYINT(1)) sea




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: