index for tables that located in different databases?

When design index for table to speed the joining, where conditions, etc,
any different comparing with tables in the same database in the same server?
and how about the tables in different server?No difference. In the end, SQL Server need to access the data. If that acces
s ban be supported by an
index (to limit number of rows to go though, support sort or grouping etc),
then it doesn't make a
difference from there the whole query originated.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"nick" <nick@.discussions.microsoft.com> wrote in message
news:BBA362DF-462E-494C-95A3-2B8A61D60A94@.microsoft.com...
> When design index for table to speed the joining, where conditions, etc,
> any different comparing with tables in the same database in the same serve
r?
> and how about the tables in different server?