CREATE NONCLUSTERED INDEX [FORUM_FORUM_ID] ON [dbo].[FORUM_REPLY] 
(
	[FORUM_ID] ASC
)
Go
CREATE NONCLUSTERED INDEX [FORUM_REPLY_CATFORTOP_ID] ON [dbo].[FORUM_REPLY] 
(
	[CAT_ID] ASC,
	[FORUM_ID] ASC,
	[TOPIC_ID] ASC
)

GO

CREATE NONCLUSTERED INDEX [FORUM_REPLY_ID] ON [dbo].[FORUM_REPLY] 
(
	[REPLY_ID] ASC
)GO

CREATE NONCLUSTERED INDEX [FORUM_REPLY_R_AUTHOR] ON [dbo].[FORUM_REPLY] 
(
	[R_AUTHOR] ASC
)
GO

CREATE NONCLUSTERED INDEX [FORUM_REPLY_TOPIC_ID] ON [dbo].[FORUM_REPLY] 
(
	[TOPIC_ID] ASC
)
GO

CREATE NONCLUSTERED INDEX [FORUM_FORUM_ID] ON [dbo].[FORUM_TOPICS] 
(
	[FORUM_ID] ASC
)
GO

CREATE NONCLUSTERED INDEX [FORUM_TOPICS_CAT_FOR_TOP] ON [dbo].[FORUM_TOPICS] 
(
	[CAT_ID] ASC,
	[FORUM_ID] ASC,
	[TOPIC_ID] ASC
)
GO

CREATE NONCLUSTERED INDEX [FORUM_TOPICS_CAT_ID] ON [dbo].[FORUM_TOPICS] 
(
	[CAT_ID] ASC
)GO

CREATE NONCLUSTERED INDEX [FORUM_TOPICS_CAT_ID_FORUM_ID] ON [dbo].[FORUM_TOPICS] 
(
	[CAT_ID] ASC,
	[FORUM_ID] ASC
)GO

CREATE NONCLUSTERED INDEX [FORUM_TOPICS_T_AUTHOR] ON [dbo].[FORUM_TOPICS] 
(
	[T_AUTHOR] ASC
)
GO

CREATE NONCLUSTERED INDEX [FORUM_TOPICS_TOPIC_ID] ON [dbo].[FORUM_TOPICS] 
(
	[TOPIC_ID] ASC
)
Go