hi,
after DTA today I see a lot like this:
CREATE PARTITION FUNCTION [pf__114](int) AS RANGE LEFT FOR VALUES (0, 3, 4, 5, 6, 10, 15, 19)go
CREATE PARTITION SCHEME [_ps__5543] AS PARTITION [pf__114] TO ([PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY])
go
CREATE VIEW [dbo].[_mv_1] WITH SCHEMABINDING
AS
SELECT [dbo].[attachment].[case_id] as _col_1, [dbo].[attachment].[bPurged] as _col_2, count_big(*) as _col_3 FROM [dbo].[attachment] GROUP BY [dbo].[attachment].[case_id],
[dbo].[attachment].[bPurged]
CREATE NONCLUSTERED INDEX [IX_cases_owned_office_id_ssnHubLocation_currentLocation_ref_barcode] ON [dbo].[cases](
[shipByDate] ASC,
[id] ASC,
.
. WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [_ps__5543]([production_line_stage])
is that mean this index [IX_cases_owned_office_id_ssnHubLocation_currentLocation_ref_barcode] already creating on the data partition?
and if I don't want the index to be created on that partition, I just remove ON [_ps__5543]([production_line_stage]) ?where [_ps__5543] is referring to one of the data partition?
CREATE NONCLUSTERED INDEX [IX_cases_owned_office_id_
[id] ASC,
.
. WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [_ps__5543]([production_li