Hi Dave (or anyone), Another quick follow up (about clustered vs nonclustered indexes) indexing the CDATA table. You mentioned creating an index on CDATA like the following (ie a clustered index).CREATE UNIQUE CLUSTERED INDEX idxCDATA ON cdata (cfid, app) It turns out that in some cases we already have an index on our client dbs as follows (ie a non-clustered index):--------------------------------------------------------------------- -----------CREATE UNIQUE NONCLUSTERED INDEX [id1] ON [dbo].[CDATA] ( [cfid] ASC, [app] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]------------------------------------------------------------------- -------------
Do you think that changing the index on this table to clustered from nonclustered would provide us with performance improvements? Thanks again! Nick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354886 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
