cong

摘要：两张表字段一样，数据量一样，不同在于主键的设置上。一个ProjectID对应多个TicketNo，TicketNo唯一，任意字母和数字的组合。主要的频率很高的查询类似：select * from dbo.EmptyTicket where projectid = 243 and statuscode = 0执行如下语句set statistics io onset statistics time onset statistics profile onselect * from dbo.EmptyTicket where projectid = 243 and statuscode = 0sel 阅读全文