I have a table with 20 millions of records called transactions. That table is partitioned by transcation_date. My question is... Can I create a non clusted index in that table even if it is partitioned. Example: CREATE NONCLUSTERED INDEX [IX_TRANSACTION_ID_TRANSACTION_DATE] ON [dbo].[transaction] ([id]) INCLUDE ([transaction_date]) GO Are there any considerations to take into account ? or what should be the best practices on it.