In contrast, bulk data insertion statements (SQL statements that insert a large number of new rows) will typically be inserted in the traditional fully-compressed column-based data page format. Data inserted via "trickle-feed" will typically be inserted uncompressed using the new efficient insert group data page format where multiple columns are grouped onto data pages for column-organized tables. In addition, the amount of storage required is reduced when column-organized tables are populated with a small number of rows using insert statements. ![]() This optimized trickle-feed insert processing is better able to apply page-based string compression which could result in better compression results than in prior releases. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |