IF NOT EXISTS (SELECT Name FROM SysIndexes  WITH (NOLOCK) WHERE Name = 'IX_GiftCertificateStatus')
  CREATE NONCLUSTERED INDEX IX_GiftCertificateStatus
  ON [dbo].[Transactions] ([ShowOnBillFlag])
  INCLUDE ([GlobalTransactionNumber],[PriceOverwrite])

IF NOT EXISTS (SELECT Name FROM SysIndexes  WITH (NOLOCK) WHERE Name = 'IX_GiftTokenNumber')
  CREATE NONCLUSTERED INDEX IX_GiftTokenNumber
  ON [dbo].[GiftToken] ([GiftTokenNumber])

IF NOT EXISTS (SELECT Name FROM SysIndexes  WITH (NOLOCK) WHERE Name = 'IX_GiftCertificateReport')
CREATE NONCLUSTERED INDEX IX_GiftCertificateReport
  ON [dbo].[Transactions] ([ShowOnBillFlag])
  INCLUDE ([Pieces],[PriceOverwrite],[OriginalGlobalTransactionNumber])