November 23, 2011 at 4:28 am
Hi,
I have my table which is daily partitioned.
When I execute the select query with date as a parameter, for the case 1 (given below) the partition count is 1 where as the partition count is 50 (all the partitions) for the case 2.
case 1. where DT='2011-08-22'
case 2. where RPT_DT={d '2011-08-22'}
If you have come across the scenario, pls help me with the reasons why case 2 fails to use the curresponding partition.
Smitha
November 23, 2011 at 5:50 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1210866-391-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply