From the course: Learning Oracle Database 12c
Join today to access over 25,500 courses taught by industry experts.
Table compression methodologies: In action - Oracle Database Tutorial
From the course: Learning Oracle Database 12c
Table compression methodologies: In action
- [Instructor] Let's try compressing some tables and see what results we get. Mainly, how big is the table after we compress it? What I'm going to do here in SQL Developer is create three sample tables, one created with no compression, one with basic compression and one with advanced compression. As a source, I'm using a data dictionary table called dbaobjects, it could be any table, I just wanted to find a table that had a number of rows in it, and as long as I'm using the same table in all the examples, it'll be a valid exercise. The first table I'm going to create is with no compression. If I specify no compression at all and the table space defaults to no compression, it'll be compressed with no compression, so go ahead and run that with create table as select, you're all friendly with that from a previous video. Go ahead and run that, alright, the table is created. I'll do the same thing, except I'm going to specify a…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.