业务表: Order-NonClusteredIndex-1 nonclustered located on PRIMARY CreateTime(-), UserName PK_u8_Order clustered, unique, primary key located on PRIMARY Id会员表: PK_u8_User_Id clustered, unique, primary key located on PRIMARY Id User-NonClusteredIndex-1 nonclustered located on PRIMARY CreateTime(-), UserName, AgentId, Sex
业务表:
Order-NonClusteredIndex-1 nonclustered located on PRIMARY CreateTime(-), UserName
PK_u8_Order clustered, unique, primary key located on PRIMARY Id会员表:
PK_u8_User_Id clustered, unique, primary key located on PRIMARY Id
User-NonClusteredIndex-1 nonclustered located on PRIMARY CreateTime(-), UserName, AgentId, Sex
2、你的慢是某个查询慢吗?是的话贴脚本看看
是发的另一个贴子里,里面有SQL。
http://bbs.csdn.net/topics/390801669