View Issue Details

IDProjectCategoryView StatusLast Update
0006678SymmetricDSImprovementpublic2024-12-13 19:06
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status assignedResolutionopen 
Product Version3.15.0 
Target Version3.16.0 
Summary0006678: Support include column for indexes for Postgres
DescriptionPostgres supports covering indexes, which allows the creation of a non-clustered index where the columns that are used for the index are set up in a b-tree data structure, and other columns can be included in the index without being a part of the b-tree index so that a query can be satisfied by only the index instead of going to the index and the table space.

DDL Utils will need to be updated to support the INCLUDE (column list) part of the index definition.

This has already been changed for SQL Server using issue 6677.
Tagsddl/schema, dialect: postgresql

Relationships

related to 0006677 assignedpmarzullo Support include column for SQL Server indexes (covering index) 

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2024-12-13 19:05 pmarzullo New Issue
2024-12-13 19:05 pmarzullo Status new => assigned
2024-12-13 19:05 pmarzullo Assigned To => pmarzullo
2024-12-13 19:05 pmarzullo Tag Attached: ddl/schema
2024-12-13 19:05 pmarzullo Tag Attached: dialect: postgresql
2024-12-13 19:06 pmarzullo Relationship added related to 0006677