Files
supabase/apps/studio/components/interfaces/Database/Indexes/Indexes.constants.ts
Ivan Vasilov 436bdb10ae chore: Move the studio app to apps/studio (#18915)
* Move all studio files from /studio to /apps/studio.

* Move studio specific prettier ignores.

* Fix the ui references from studio.

* Fix the css imports.

* Fix all package.json issues.

* Fix the prettier setup for the studio app.

* Add .turbo folder to prettierignore.

* Fix the github workflows.
2023-11-15 12:38:55 +01:00

34 lines
830 B
TypeScript

export const INDEX_TYPES = [
{
name: 'B-Tree',
value: 'btree',
description:
'For querying data with equality or range conditions on columns.\nThis is the default index type that Postgres uses.',
},
{
name: 'Hash',
value: 'hash',
description: 'For querying exact matches on columns',
},
{
name: 'GiST',
value: 'gist',
description: 'For querying complex data types or custom-defined operators',
},
{
name: 'SP-GiST',
value: 'spgist',
description: 'Similar to GiST, but is more specialized and customizable',
},
{
name: 'GIN',
value: 'gin',
description: 'For querying multi-valued data such as arrays or full-text search scenarios',
},
{
name: 'BRIN',
value: 'brin',
description: 'For querying large tables with sorted data',
},
]