Adding non cluster index on OutSystems entity

I have a requirement where I need to add non cluster indexes on multiple columns while another(one) column being an include column for the index on a particular entity .

Can someone please help how we can achieve on a OutSystems Entity .

Thanks and best regards

25 Feb

José Gonçalves

Champion

Solution

Hi Rishav,

editing an entity will allow you to add more indexes (composite too).

Regards

25 Feb

1 reply

25 Feb

Show thread

Hide thread

rishav tiwari

Thanks Jose for your quick response !!

How can we include a column as well in the non cluster index as MS SQL Server provide an option to do that please ?

25 Feb

José Gonçalves

Champion

You're right, it's no possible to create indexes with Include columns.

I remember an idea I submitted to allow that but I think the main reason for that limitation is because in Oracle there is no "Include columns" feature in indexes.

Regards

25 Feb

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines