Enum IndexChoice 

pub enum IndexChoice {
    Any,
    NotIndexed,
    Only(Vec<u8>),
}

Which indexes the planner may use for one FROM term.

SQLite’s two clauses are opposite restrictions and the planner reads them in one place, choose_path. NOT INDEXED takes every index away and leaves the rowid. INDEXED BY takes everything else away, the rowid and the table scan included: the pinned 3.53.4 shell plans SELECT * FROM h INDEXED BY h_a WHERE id = 5 as SCAN h USING INDEX h_a, a walk of the whole index, with a rowid seek sitting unused beside it.

Variants

Any

Nothing was written, so every path is a candidate.

NotIndexed

NOT INDEXED: no index, and the rowid is still allowed.

Only(Vec<u8>)

INDEXED BY name: that index and nothing else, by its folded name.

Trait Implementations

impl Clone for IndexChoice

fn clone(&self) -> Self

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for IndexChoice

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

Formats the value using the given formatter.

impl Default for IndexChoice

fn default() -> Self

Returns the “default value” for a type.

impl Eq for IndexChoice

impl PartialEq for IndexChoice

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

Equality operator ==.

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

Inequality operator !=.

impl StructuralPartialEq for IndexChoice