hello
I have created a function but it takes good amount of time
CREATE FUNCTION dbo.fnMusic()
RETURNS TABLE
AS
RETURN

(SELECT dbo.tbl_A.Primary_Key ,tbl_A.Title, tbl_B.price
FROM dbo.tbl_A
LEFT OUTER JOIN dbo.tbl_B ON dbo.tbl_A.Primary_Key = dbo.tbl_B.primary_key)

there are 30,000 records in tbl_A
and 20 lacs records in tbl_B

Please tell me the solution for this i have already created the indexing on all the above mentioned fields.

thanks in advance