Analytics Optimization with Columnstore Indexes in Microsoft SQL Server by Unknown
Author:Unknown
Language: eng
Format: epub, pdf
Chapter 9 Delete anD UpDate OperatiOns
The rowgroup metadata can be seen in Figure 9-4.
Figure 9-4. Rowgroup metadata for a columnstore index, including deleted rows As is expected of a columnstore index that has had no delete operations executed against it, the deleted_rows column in sys.column_store_row_groups shows zero for each rowgroup. Executing the query in Listing 9-1 will delete a total of 15,400 rows from the columnstore index. Figure 9-5 shows the metadata details for the columnstore index after the deletion has completed.
Figure 9-5. Rowgroup metadata after a deletion has occurred
Each rowgroup now contains some number of deleted rows, depending on the
number of rows within them that happen to have been invoiced on 1/1/2016. Note that the total rows in each rowgroup and the size in bytes have not changed. This is expected and reflects the fact that rows were soft deleted via the delete bitmap.
127
Download
Analytics Optimization with Columnstore Indexes in Microsoft SQL Server by Unknown.pdf
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.
NET | C & C++ Windows Programming |
SQL Server | VBA |
Visual Basic |
Deep Learning with Python by François Chollet(12555)
Hello! Python by Anthony Briggs(9904)
OCA Java SE 8 Programmer I Certification Guide by Mala Gupta(9785)
The Mikado Method by Ola Ellnestam Daniel Brolund(9769)
Dependency Injection in .NET by Mark Seemann(9329)
Algorithms of the Intelligent Web by Haralambos Marmanis;Dmitry Babenko(8282)
Test-Driven iOS Development with Swift 4 by Dominik Hauser(7756)
Grails in Action by Glen Smith Peter Ledbrook(7686)
The Well-Grounded Java Developer by Benjamin J. Evans Martijn Verburg(7550)
Becoming a Dynamics 365 Finance and Supply Chain Solution Architect by Brent Dawson(7009)
Microservices with Go by Alexander Shuiskov(6776)
Practical Design Patterns for Java Developers by Miroslav Wengner(6687)
Test Automation Engineering Handbook by Manikandan Sambamurthy(6630)
Secrets of the JavaScript Ninja by John Resig Bear Bibeault(6400)
Angular Projects - Third Edition by Aristeidis Bampakos(6037)
The Art of Crafting User Stories by The Art of Crafting User Stories(5567)
NetSuite for Consultants - Second Edition by Peter Ries(5499)
Demystifying Cryptography with OpenSSL 3.0 by Alexei Khlebnikov(5304)
Kotlin in Action by Dmitry Jemerov(5048)
