Adding nonclustered Index with INCLUDE.

[btagliani]

Hi everyone! I was wondering if there's any way to create an index like this:
CREATE NONCLUSTERED INDEX IndexName ON [dbo].[table] ([id],[type],[for_type],[attrib]) INCLUDE ([for_id],[value])
with ActiveRecord?

[metaskills]

Just use the execute method in migrations when you need to do anything off the beaten path.

[erlingur]

@metaskills This is now supported from Rails but when running this the index does not get correctly created with the INCLUDE. Which means it will not be supported in the schema.rb file which means you have to find a way to somehow run a separate script to set these covering indexes up after a new installation.

rails/rails#44803

It would be great if this gem could support this. I have a performance issue in an app that I need to solve with covering indexes and having this built into the schema.rb file would be great.

[erlingur]

@aidanharan Thank you for reopening this! :) Hopefully this can get integrated.

[aidanharan]

INDEX INCLUDE has been added to the adapter for v8.1 in #1301

[erlingur]

Awesome, thank you so much @aidanharan !!