Friday, March 7, 2008

SQL Server Table Hint

SELECT
r.rlai_status,r.rlai_rowidno,r.rlai_recorddatetime,
c.cust_no,c.cust_parentrowidno,c.cust_salaryincome,
c.cust_extraincome
FROM dbo.tbl_customers c with(nolock,index(IDX_cust_parentrowid)),dbo.rloan_appinfo r with(nolock, index(IDX_status))
WHERE
c.cust_parentrowidno = r.rlai_rowidno
AND r.rlai_status='3'
AND c.cust_parentprocessid=7
AND c.cust_type = 'B'

No comments: