SQL Server 2005 Partition + Performance Issues

[sendba]

Hi,

I have created a SQL Server Partition on a 300 Million record table last year and now that it is fragmented. I would like to defrag it using sql Server 2005 Alter index statement.

The fifth partition is fragmented, so I ran the following statement to defrag during the maintenance window

Alter index .... partition = 5

And the fragmentation reduced to 2% but the performance of the query which should access this index is not performing properly.
Any idea what went wrong.

Please help.

Thanks

 

[MissTipps]

You say "..should access.." Have you checked the execution plan to see that the query is actually using the index?

MissTipps

CISSP, CEH, CEI, MCT, MCDBA, MCSE 2K3, CTT+, ECSA, Security+