Thanks for the reply...

For example i've two databases called "dbFirst" and "dbSecond".

In dbSecond i've a table called "EmployeeTable".

I'm going to create a view called "EmployeeView" in dbFirst database with

Select

EmployeeNumber,

EmployeeName

From

dbSecond.dbo.EmployeeTable

I want to create a index (either clustered or non-clustered) for this view as my view containing millions of records and i dont want to wait for the retrieval. If i want to create index for this view which is located in dbFirst referring dbSecond, i'm unable to do. Could you suggest me whether there is any alternate way to achieve this?