摘要:
两张表字段一样,数据量一样,不同在于主键的设置上。一个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 阅读全文