Index Build strategy in SQL Server – Part 2: Offline, Parallel, No Partitioning (Non stats plan (no histogram))

When histogram is not available (for example when we building an index on a view) we can’t use the same methods as described in previous post (For statistics gathering, it is possible only for ‘real’ object. We are building index on view, so index does not exist at this point and we are not able to

Read More - Register for Free Membership