Special Offer Get 50% OFF Lifetime Access - Limited Time Offer!

Improved Query - SQL Server

Shared by Manish Sharma on Apr 7, 2025

SQL Query

sqlserver
CREATE NONCLUSTERED INDEX IX_gas_supply_CreatedOn_UserIdName ON [dbo].[gas_supply] (CreatedOn) INCLUDE (UserIdName, Column1, Column2, Column3, ..., ColumnN); SELECT * FROM [dbo].[gas_supply] WHERE CreatedOn >= DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) - 1, 0) AND CreatedOn < DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0) AND UserIdName = 'User1';