We currently use partitioned views (over horizontally partitioned tables) in SQL Server 2000. The tables are partitioned by month. This works extremely well for our needs. In evaluating SQL Server 2005 Standard Edition, we are finding some issues trying to get this to work properly. A select against the view results in a table scan. Does anyone know if partitioned views have any issues in 2005 SE We are not doing anything different in 2005 SE than we currently do in 2000 SE.
Using Partitioned Views in SQL Server 2005 Standard Edition
Hot Topic
- .sdf deployment problem VS2005
- Unable to use Books Online search function
- Performance Problem
- Inner Join matches non-equal fields??????
- Droppinga a default value
- need to edit .sdf files from local desktop
- SSIS and COM
- what is [SQL-DMO]
- Lookup - full caching vs partial caching vs no caching
- Toggle help...
SQL Server
- OMAP850 support?
- Problem to install SQL Server 2005 CTP June edition...
- Error in sql server 2005 developer edition.
- How To Avoid Table Scan
- about processXMLdata sample,how to insert a return in end of each row data of the result text file?
- Clearing cache
- Problems with report fitting to a page when exporting and then printing from Excel
- Failing to install SQL2005 Express and Standard Edition on Via Eden CPU.
- ReportViewer control for WinForms - can I copy text?
- Is this method possible?
Using Partitioned Views in SQL Server 2005 Standard Edition
StuartRothrock
StephanG,
Would you please post your query and the query plan by the following commands
set showplan_text on
<run your query here>
set showplan_text off
Thanks,
- Ming