How do I create a function based index in Erwin? PostgreSQL example (4292891)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

How do I create a function based index in Erwin? PostgreSQL example
Description

How do I create a function based index in Erwin? PostgreSQL example
Resolution

Question:

How do I create a function based index in Erwin? Any example for PostgreSQL?

Solution:

Add a new IE index. Create a new expression on that index. Type your expression into the Column/Expression field.

In the Schema generation turn on IE indexes

The function based index will be generated