StorageFormat

Enum StorageFormat 

Source
pub enum StorageFormat {
    Row,
    Columnar,
}
Expand description

Storage format for tables

Tables can be stored in row-oriented (default) or columnar format. Columnar storage is optimized for analytical queries (OLAP) with SIMD-accelerated scans and aggregations.

§Usage

-- Create a columnar table for analytics
CREATE TABLE lineitem (...) STORAGE COLUMNAR;

-- Explicitly create a row-oriented table
CREATE TABLE orders (...) STORAGE ROW;

§Performance Trade-offs

FormatINSERTPoint QueryScanAggregation
RowO(1)O(1) indexO(n)O(n)
ColumnarO(n)*O(n)O(n) SIMDO(n) SIMD

*Columnar INSERT triggers full rebuild - use for bulk-load scenarios only.

Variants§

§

Row

Traditional row-oriented storage (default)

Optimized for OLTP workloads: fast inserts, point lookups. Use for tables with frequent writes or transactional access patterns.

§

Columnar

Native columnar storage for analytical tables

Optimized for OLAP workloads: fast scans, aggregations. Eliminates row-to-columnar conversion overhead for analytical queries.

Warning: Each write operation (INSERT/UPDATE/DELETE) triggers a full rebuild of the columnar representation. Only use for tables that are bulk-loaded and rarely modified.

Trait Implementations§

Source§

impl Clone for StorageFormat

Source§

fn clone(&self) -> StorageFormat

Returns a duplicate of the value. Read more
1.0.0 · Source§

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source. Read more
Source§

impl Debug for StorageFormat

Source§

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter. Read more
Source§

impl Default for StorageFormat

Source§

fn default() -> StorageFormat

Returns the “default value” for a type. Read more
Source§

impl Display for StorageFormat

Source§

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter. Read more
Source§

impl PartialEq for StorageFormat

Source§

fn eq(&self, other: &StorageFormat) -> bool

Tests for self and other values to be equal, and is used by ==.
1.0.0 · Source§

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.
Source§

impl Copy for StorageFormat

Source§

impl Eq for StorageFormat

Source§

impl StructuralPartialEq for StorageFormat

Auto Trait Implementations§

Blanket Implementations§

Source§

impl<T> Any for T
where T: 'static + ?Sized,

Source§

fn type_id(&self) -> TypeId

Gets the TypeId of self. Read more
Source§

impl<T> Borrow<T> for T
where T: ?Sized,

Source§

fn borrow(&self) -> &T

Immutably borrows from an owned value. Read more
Source§

impl<T> BorrowMut<T> for T
where T: ?Sized,

Source§

fn borrow_mut(&mut self) -> &mut T

Mutably borrows from an owned value. Read more
Source§

impl<T> CloneToUninit for T
where T: Clone,

Source§

unsafe fn clone_to_uninit(&self, dest: *mut u8)

🔬This is a nightly-only experimental API. (clone_to_uninit)
Performs copy-assignment from self to dest. Read more
Source§

impl<T> From<T> for T

Source§

fn from(t: T) -> T

Returns the argument unchanged.

Source§

impl<T, U> Into<U> for T
where U: From<T>,

Source§

fn into(self) -> U

Calls U::from(self).

That is, this conversion is whatever the implementation of From<T> for U chooses to do.

Source§

impl<T> ToOwned for T
where T: Clone,

Source§

type Owned = T

The resulting type after obtaining ownership.
Source§

fn to_owned(&self) -> T

Creates owned data from borrowed data, usually by cloning. Read more
Source§

fn clone_into(&self, target: &mut T)

Uses borrowed data to replace owned data, usually by cloning. Read more
Source§

impl<T> ToString for T
where T: Display + ?Sized,

Source§

fn to_string(&self) -> String

Converts the given value to a String. Read more
Source§

impl<T, U> TryFrom<U> for T
where U: Into<T>,

Source§

type Error = Infallible

The type returned in the event of a conversion error.
Source§

fn try_from(value: U) -> Result<T, <T as TryFrom<U>>::Error>

Performs the conversion.
Source§

impl<T, U> TryInto<U> for T
where U: TryFrom<T>,

Source§

type Error = <U as TryFrom<T>>::Error

The type returned in the event of a conversion error.
Source§

fn try_into(self) -> Result<U, <U as TryFrom<T>>::Error>

Performs the conversion.