It is trivial to add support for INCLUDE() and WHERE() clauses on SQL Server indexes in PeopleSoft – just change the model DDL for Index creation to have the two optional clauses defaulted to blank and then override on the specific index as needed:
Obviously, at the individual index level you will need the full syntax including the keywords e.g.
INCLUDE (col1,col2,col3 …)
WHERE (criteria)
Be aware that the criteria you can include is limited – refer to the Microsoft documentation for more details.
One reply on “PeopleSoft – INCLUDE and WHERE (filtering) on SQL Server Indexes”
[…] (DDL defaults etc) to add things like INCLUDE and WHERE support to indexes on SQL Server (see PeopleSoft – INCLUDE and WHERE (filtering) on SQL Server Indexes for details on how to do this within […]