Can you post the data/index DDL?
Why don't you use INT/BIGINT surrogate PRIMARY KEYs?
JOINing millions of records(rows) on text columns will result in a performance hit.
Optimization article:
http://www.sqlusa.com/articles/query-optimization/
Kalman Toth Database & OLAP Architect sqlusa.com
New Book / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012
No comments:
Post a Comment