Compressed Tables Table Compression is suitable - wykład

Nasza ocena:

3
Wyświetleń: 280
Komentarze: 0
Notatek.pl

Pobierz ten dokument za darmo

Podgląd dokumentu
Compressed Tables Table Compression is suitable - wykład - strona 1

Fragment notatki:

Compressed Tables Table Compression is suitable for both OLTP applications and data
warehousing applications. Compressed tables require less disk storage and result in
improved query performance due to reduced I/O and buffer cache requirements.
Compression is transparent to applications and incurs minimal overhead during bulk
loading or regular DML operations such as INSERT, UPDATE or DELETE.
To configure table compression using SQL Developer, click the Advanced checkbox
when creating a table. Then click Table Properties and enable the Compression
option.
... zobacz całą notatkę

Komentarze użytkowników (0)

Zaloguj się, aby dodać komentarz