CREATE VIEW dbo.vTabla_Java
WITH schemaBinding
AS
	SELECT 
		[tj_ID]
		,[tj_IsJava] = CAST(CASE WHEN (len([tj_Title])-len(replace([tj_Title],'java',''))) <> 0 THEN 1 ELSE 0 END AS BIT)
		,tj_DiffTitleLength = len([tj_Title])-len(replace([tj_Title],'java',''))
	FROM 
		[dbo].[Table_Java]
GO

CREATE UNIQUE CLUSTERED INDEX idx_vTabla_Java_U_C_ID
    ON dbo.vTabla_Java (tj_ID);
GO

CREATE NONCLUSTERED INDEX idx_vTabla_Java_NC_DiffTitleLength
    ON dbo.vTabla_Java (tj_DiffTitleLength);
GO

CREATE NONCLUSTERED INDEX idx_vTabla_Java_NC_IsJava
    ON dbo.vTabla_Java (tj_IsJava);
GO

SELECT tj_ID 	
FROM dbo.vTabla_Java
WHERE tj_IsJava =1