New Trace flags for better maintenance of deleted rows in Columnstore Index

Published 02-12-2021 12:30 AM 1,180 Views
Microsoft

Qualification Limit for REORGANIZE to remove deleted rows from a rowgroup in Columnstore Index:

By default when one runs ALTER INDEX REORGANIZE the qualifying limit to remove delete rows from a rowgroup is --> the specific rowgroup have 10% of the max possible rows in a rowgroup deleted.

 

As the max possible rows in a row group is 1 million rows, the qualification limit is 10%, which is 100K rows deleted in a row group before the Reorganize removes them from the rowgroup.

 

From <https://docs.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?vie...>

 

This threshold limit has few concerns

 

  1. for few groups which are  of full size of 1M rows, reaching 100K deleted rows may take a long time and until then the deleted rows are not cleared.
  2. For smaller rowgroups, the percentage of deleted rows will be huge but still the deleted rows will not be considered done.

 

 

New Trace flags from SQL 2019 CU9:

 

From SQL 2019 CU9 we have introduced 2 new trace flags for better management of the deleted rows.

 

Trace flag 11631 --> will not use the ~1M rows to calculate the 10%, but rather it will use the actual no of rows in a rowgroup.

Therefore if your rowgroup has only 20000 (20 k) rows, the limit comes to 10% of 20000 i.e to 2000 deleted rows, Thus, if have >= 2k rows deleted REORG will consider this rowgroup for cleanup of deleted rows

 

Trace flag 11634 --> will bring down the Percentage of deleted rows limit from 10%  to 1%. If enabled together with trace flag 11631 then it will be 1% of the current number of rows in a rowgroup, instead of 1% of 1 million rows .

 

For example,

 

drop table TABLE1

 

--> create table

create table TABLE1

(

roll int,

Name char(10)

 

)

 

-->insert 5K rows

declare @i int

set @i=0;

while (@i<5000)

begin

insert into TABLE1 values (@i,'test');

set @i=@i+1;

end

 

--> Create a columnstore index

CREATE CLUSTERED COLUMNSTORE INDEX [TABLE1_CCIindex] ON dbo.TABLE1 WITH (DROP_EXISTING OFF)

GO

 

--> Delte 3.5K rows (70% rows)

delete from TABLE1 where roll<3500

 

--> checking rowgroup properies

SELECT rg.total_rows,

              cast(100.0*(total_rows ISNULL(deleted_rows,0))/iif(total_rows = 0, 1, total_rowsas Decimal(6,3)) AS PercentFull,

    100-cast(100.0*(total_rows ISNULL(deleted_rows,0))/iif(total_rows = 0, 1, total_rowsas Decimal(6,3)) as PercentDeleted,

              i.object_idobject_name(i.object_idAS TableName,

              i.name AS IndexName, i.index_id, i.type_desc,

              rg.*

       FROM sys.indexes AS i

       INNEr JOIN sys.column_store_row_groups AS rg

              ON i.object_id = rg.object_id

       AND i.index_id = rg.index_id

       WHERE object_name(i.object_id) = 'TABLE1'

       ORDER BY object_name(i.object_id), i.name, row_group_id;

 

--> Even though 70% of the rows are deleted,  the REORGANIZE won’t consider this rowgroup for cleanup of the deleted rows.

 

ALTER INDEX [TABLE1_CCIindex] ON dbo.TABLE1 REORGANIZE  à has no affect and the deleted rows wont be cleared

 

HemanthTarra_0-1613118494276.png

 

dbcc traceon(11631,-1--> The threshold limit is now calculated for the 5K rows but not 1M rows. i.e So the limit comes down to 10% of 5K i.e >= 500 deleted rows.

dbcc traceon(11634,-1--> Brings down the threshold limit further from 10% to 1% i.e  from 500 to 50 deleted rows.

  

Now after the Trace flags are enabled, when we run the

 

ALTER INDEX [TABLE1_CCIindex] ON dbo.TABLE1 REORGANIZE --> effectively cleans up the deleted rows

 

 

HemanthTarra_1-1613118494283.png

 

 

%3CLINGO-SUB%20id%3D%22lingo-sub-2127034%22%20slang%3D%22en-US%22%3ENew%20Trace%20flags%20for%20better%20maintenance%20of%20deleted%20rows%20in%20Columnstore%20Index%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2127034%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3E%3CU%3EQualification%20Limit%20for%20REORGANIZE%20to%20remove%20deleted%20rows%20from%20a%20rowgroup%20in%20Columnstore%20Index%3A%3C%2FU%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EBy%20default%20when%20one%20runs%20ALTER%20INDEX%20REORGANIZE%20the%20qualifying%20limit%20to%20remove%20delete%20rows%20from%20a%20rowgroup%20is%20--%26gt%3B%20the%20specific%20rowgroup%20have%2010%25%20of%20the%26nbsp%3B%3CSTRONG%3Emax%20possible%20rows%3C%2FSTRONG%3E%26nbsp%3Bin%20a%20rowgroup%20deleted.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20the%20max%20possible%20rows%20in%20a%20row%20group%20is%201%20million%20rows%2C%20the%20qualification%20limit%20is%2010%25%2C%20which%20is%26nbsp%3B%3CSTRONG%3E100K%20rows%3C%2FSTRONG%3E%26nbsp%3Bdeleted%20in%20a%20row%20group%20before%20the%20Reorganize%20removes%20them%20from%20the%20rowgroup.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFrom%20%26lt%3B%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fdocs.microsoft.com%252Fen-us%252Fsql%252Frelational-databases%252Findexes%252Freorganize-and-rebuild-indexes%253Fview%253Dsql-server-ver15%2523defragmenting-indexes-by-rebuilding-or-reorganizing-the-index%26amp%3Bdata%3D04%257C01%257Chetarra%2540microsoft.com%257C26fe4aa355304748b99408d8c9334e4c%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637480569490415324%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C1000%26amp%3Bsdata%3DYbXSoufoJWB31mEyEovj9LCQ9izKicohWRP9IbgA2jg%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Findexes%2Freorganize-and-rebuild-indexes%3Fvie...%3C%2FA%3E%26gt%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20threshold%20limit%20has%20few%20concerns%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3Efor%20few%20groups%20which%20are%26nbsp%3B%20of%20full%20size%20of%201M%20rows%2C%20reaching%20100K%20deleted%20rows%20may%20take%20a%20long%20time%20and%20until%20then%20the%20deleted%20rows%20are%20not%20cleared.%3C%2FLI%3E%0A%3CLI%3EFor%20smaller%20rowgroups%2C%20the%20percentage%20of%20deleted%20rows%20will%20be%20huge%20but%20still%20the%20deleted%20rows%20will%20not%20be%20considered%20done.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CU%3ENew%20Trace%20flags%20from%20SQL%202019%20CU9%3A%3C%2FU%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFrom%20SQL%202019%20CU9%20we%20have%20introduced%202%20new%20trace%20flags%20for%20better%20management%20of%20the%20deleted%20rows.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ETrace%20flag%26nbsp%3B11631%20--%26gt%3B%26nbsp%3B%3C%2FSTRONG%3Ewill%20not%20use%20the%20~1M%20rows%20to%20calculate%20the%2010%25%2C%20but%20rather%20it%20will%20use%20the%20actual%20no%20of%20rows%20in%20a%20rowgroup.%3C%2FP%3E%0A%3CP%3ETherefore%20if%20your%20rowgroup%20has%20only%2020000%20(20%20k)%20rows%2C%20the%20limit%20comes%20to%2010%25%20of%2020000%20i.e%20to%202000%20deleted%20rows%2C%20Thus%2C%20if%20have%20%26gt%3B%3D%202k%20rows%20deleted%20REORG%26nbsp%3Bwill%20consider%20this%20rowgroup%20for%20cleanup%20of%20deleted%20rows%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ETrace%20flag%2011634%20--%26gt%3B%26nbsp%3B%3C%2FSTRONG%3Ewill%20bring%20down%20the%20Percentage%20of%20deleted%20rows%20limit%20from%2010%25%26nbsp%3B%20to%201%25.%20If%20enabled%20together%20with%20trace%20flag%2011631%20then%20it%20will%20be%201%25%20of%20the%20current%20number%20of%20rows%20in%20a%20rowgroup%2C%20instead%20of%201%25%20of%201%20million%20rows%20.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EFor%20example%2C%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3Edrop%20table%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3BTABLE1%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%20color%3A%20black%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%20color%3A%20green%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E--%26gt%3B%20create%20table%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3Ecreate%20table%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3BTABLE1%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%20color%3A%20gray%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E(%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3Eroll%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3Eint%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3EName%20char%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E10%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E)%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%20color%3A%20black%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%20color%3A%20gray%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E)%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%20color%3A%20black%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%20color%3A%20green%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E--%26gt%3Binsert%205K%20rows%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3Edeclare%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3B%40i%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3Eint%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3Eset%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3B%40i%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E0%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3Ewhile%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%40i%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%26lt%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E5000%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E)%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%20color%3A%20blue%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3Ebegin%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3Einsert%20into%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3BTABLE1%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3Evalues%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%40i%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20red%3B%20background%3A%20white%3B%22%3E'test'%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E)%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3Eset%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3B%40i%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%40i%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%2B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E1%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%20color%3A%20blue%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3Eend%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%20color%3A%20black%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%20color%3A%20green%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E--%26gt%3B%20Create%20a%20columnstore%20index%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3ECREATE%20CLUSTERED%20COLUMNSTORE%20INDEX%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3B%5BTABLE1_CCIindex%5D%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3EON%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3Bdbo%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3ETABLE1%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3EWITH%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3EDROP_EXISTING%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%3D%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3EOFF%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E)%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%20color%3A%20blue%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3EGO%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%20color%3A%20black%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%20color%3A%20green%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E--%26gt%3B%20Delte%203.5K%20rows%20(70%25%20rows)%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3Edelete%20from%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3BTABLE1%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3Ewhere%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3Broll%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%26lt%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E3500%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20'Segoe%20UI'%3B%20font-size%3A%2010.5pt%3B%20color%3A%20%23252423%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%20color%3A%20green%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E--%26gt%3B%20checking%20rowgroup%20properies%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3ESELECT%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3Brg%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3Etotal_rows%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20fuchsia%3B%20background%3A%20white%3B%22%3Ecast%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E100.0%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E*(%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3Etotal_rows%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E-%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20fuchsia%3B%20background%3A%20white%3B%22%3EISNULL%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3Edeleted_rows%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E0%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E))%2F%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20fuchsia%3B%20background%3A%20white%3B%22%3Eiif%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3Etotal_rows%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3B0%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3B1%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3Btotal_rows%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E)%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3Eas%20Decimal%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E6%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E3%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E))%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3EAS%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3BPercentFull%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.75in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B100%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E-%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20fuchsia%3B%20background%3A%20white%3B%22%3Ecast%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E100.0%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E*(%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3Etotal_rows%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E-%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20fuchsia%3B%20background%3A%20white%3B%22%3EISNULL%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3Edeleted_rows%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E0%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E))%2F%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20fuchsia%3B%20background%3A%20white%3B%22%3Eiif%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3Etotal_rows%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3B0%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3B1%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3Btotal_rows%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E)%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3Eas%20Decimal%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E6%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E3%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E))%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3Eas%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3BPercentDeleted%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20i%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20fuchsia%3B%20background%3A%20white%3B%22%3Eobject_id%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20fuchsia%3B%20background%3A%20white%3B%22%3Eobject_name%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3Ei%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20fuchsia%3B%20background%3A%20white%3B%22%3Eobject_id%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E)%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3EAS%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3BTableName%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3Bi%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3Ename%20AS%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3BIndexName%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3Bi%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3Eindex_id%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3Bi%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3Etype_desc%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3Brg%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E.*%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3EFROM%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20lime%3B%20background%3A%20white%3B%22%3Esys%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20lime%3B%20background%3A%20white%3B%22%3Eindexes%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3EAS%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3Bi%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3EINNEr%20JOIN%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20lime%3B%20background%3A%20white%3B%22%3Esys%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20lime%3B%20background%3A%20white%3B%22%3Ecolumn_store_row_groups%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3EAS%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3Brg%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3EON%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3Bi%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20fuchsia%3B%20background%3A%20white%3B%22%3Eobject_id%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3Brg%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20fuchsia%3B%20background%3A%20white%3B%22%3Eobject_id%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3EAND%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3Bi%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3Eindex_id%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3Brg%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3Eindex_id%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3EWHERE%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20fuchsia%3B%20background%3A%20white%3B%22%3Eobject_name%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3Ei%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20fuchsia%3B%20background%3A%20white%3B%22%3Eobject_id%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E)%20%3D%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20red%3B%20background%3A%20white%3B%22%3E'TABLE1'%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3EORDER%20BY%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20fuchsia%3B%20background%3A%20white%3B%22%3Eobject_name%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3Ei%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20fuchsia%3B%20background%3A%20white%3B%22%3Eobject_id%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E)%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3Bi%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3Ename%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3Brow_group_id%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Helvetica%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%20color%3A%20green%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E--%26gt%3B%20Even%20though%2070%25%20of%20the%20rows%20are%20deleted%2C%26nbsp%3B%20the%20REORGANIZE%20won%E2%80%99t%20consider%20this%20rowgroup%20for%20cleanup%20of%20the%20deleted%20rows.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%20color%3A%20black%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22font-family%3A%20Consolas%3B%20color%3A%20blue%3B%20background%3A%20white%3B%22%3EALTER%20INDEX%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-family%3A%20Consolas%3B%20color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3B%5BTABLE1_CCIindex%5D%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-family%3A%20Consolas%3B%20color%3A%20blue%3B%20background%3A%20white%3B%22%3EON%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-family%3A%20Consolas%3B%20color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3Bdbo%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-family%3A%20Consolas%3B%20color%3A%20gray%3B%20background%3A%20white%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-family%3A%20Consolas%3B%20color%3A%20black%3B%20background%3A%20white%3B%22%3ETABLE1%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-family%3A%20Consolas%3B%20color%3A%20blue%3B%20background%3A%20white%3B%22%3EREORGANIZE%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-family%3A%20Consolas%3B%20color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-family%3A%20Wingdings%3B%20color%3A%20green%3B%20background%3A%20white%3B%22%3E%C3%A0%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-family%3A%20Calibri%3B%20color%3A%20green%3B%20background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-family%3A%20Consolas%3B%20color%3A%20green%3B%20background%3A%20white%3B%22%3Ehas%20no%20affect%20and%20the%20deleted%20rows%20wont%20be%20cleared%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22HemanthTarra_0-1613118494276.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F254409iA09FC975A46D0051%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22HemanthTarra_0-1613118494276.png%22%20alt%3D%22HemanthTarra_0-1613118494276.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%20style%3D%22direction%3A%20ltr%3B%20border-width%3A%20100%25%3B%22%3E%0A%3CDIV%20style%3D%22direction%3A%20ltr%3B%20margin-top%3A%200in%3B%20margin-left%3A%200in%3B%20width%3A%207.5in%3B%22%3E%0A%3CDIV%20style%3D%22direction%3A%20ltr%3B%20margin-top%3A%200in%3B%20margin-left%3A%200in%3B%20width%3A%207.5in%3B%22%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3Edbcc%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3Btraceon%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E11631%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%2C-%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E1%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E)%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20green%3B%20background%3A%20white%3B%22%3E--%26gt%3B%20The%20threshold%20limit%20is%20now%20calculated%20for%20the%205K%20rows%20but%20not%201M%20rows.%20i.e%20So%20the%20limit%20comes%20down%20to%2010%25%20of%205K%20i.e%20%26gt%3B%3D%20500%20deleted%20rows.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3Edbcc%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3Btraceon%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E11634%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E%2C-%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E1%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E)%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20green%3B%20background%3A%20white%3B%22%3E--%26gt%3B%20Brings%20down%20the%20threshold%20limit%20further%20from%2010%25%20to%201%25%20i.e%26nbsp%3B%20from%20500%20to%2050%20deleted%20rows.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%20color%3A%20blue%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Helvetica%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3ENow%20after%20the%20Trace%20flags%20are%20enabled%2C%20when%20we%20run%20the%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Helvetica%3B%20font-size%3A%2012.0pt%3B%20color%3A%20%23333333%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22background%3A%20white%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%209.5pt%3B%22%20lang%3D%22en-US%22%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3EALTER%20INDEX%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3B%5BTABLE1_CCIindex%5D%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3EON%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3E%26nbsp%3Bdbo%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20gray%3B%20background%3A%20white%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%20background%3A%20white%3B%22%3ETABLE1%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%20background%3A%20white%3B%22%3EREORGANIZE%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20green%3B%20background%3A%20white%3B%22%3E--%26gt%3B%20effectively%20cleans%20up%20the%20deleted%20rows%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22HemanthTarra_1-1613118494283.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F254410i69A50CA8C7409F0F%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22HemanthTarra_1-1613118494283.png%22%20alt%3D%22HemanthTarra_1-1613118494283.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Co-Authors
Version history
Last update:
‎Feb 12 2021 12:30 AM
Updated by: