Skip to content

Add index on metadata columns of view tables #3531

@joshua-spacetime

Description

@joshua-spacetime

Specifically when we create a view's backing table, we should create a multi-column index on [sender, arg_id] so that we can quickly scan or delete result sets.

Note that if a view is parameterized or if a view is not anonymous, the backing table stores the results of potentially many different callers. We don't want to have to scan the entire table when only looking for the result set of one individual caller.

Metadata

Metadata

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions