USE [behtop]
GO
/****** Object: StoredProcedure [dbo].[GetCustomersPageWise1] Script Date: 01/14/2013 15:04:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[GetCustomersPageWise1]
@H_name nvarchar(50)
,@subset nvarchar(30)
,@PageIndex INT = 1
,@PageSize INT = 5
,@RecordCount INT OUTPUT
,@Region nvarchar(10)
,@district nvarchar(20)
,@shoppingcenter nvarchar(30)
,@labeltext nvarchar(30) OUTPUT
,@labeltext1 nvarchar(30) OUTPUT
,@Id int
AS
BEGIN
SET NOCOUNT ON;
SELECT ROW_NUMBER() OVER
(
ORDER BY [House_p].[Date] desc
)AS RowNumber
,[House_p].[ID]
,[House_p].[Name]
,[House_p].[Image]
,[House_p].[Date]
,House_Info.Name as NameI
,[House_p].[Model]
,(House_info.Code+'-'+House_info.Tell) as tellF
,House_Info.BehCode as Behcode
INTO #Results
FROM [House_p]
JOIN [HOuse_info] ON [House_p].[BehCode] = [HOuse_info].[BehCode]
WHERE ([House_p].H_name=@H_name or [House_p].Classification=@subset) and ([HOuse_info].Region = @Region or @Region='همه') and ([House_Info].District=@District or @District='همه') and ([House_Info].ShoppingCenter=@shoppingcenter or @shoppingcenter='همه')
SELECT @RecordCount = COUNT(*)
FROM #Results
SELECT * FROM #Results
WHERE (RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1)
DROP TABLE #Results
SELECT @labelText=(SELECT Name FROM House_menu WHERE ID=@Id)
SELECT @labelText1=(SELECT Name FROM House_classification WHERE ID=@Id)
END
اینم کد من میخوام بدونم ایندکس گذاری روی سرعت ججستجو در Sql تاثیر داره؟