vinay bhushan <bhushanvinay@mail.com> wrote in message news:<409b0dac$0$204$75868355@news.frii.net>...
> Can we make a Index on 2 or more tables
>
> Table a:
> Col1 int
> col2 varchar
>
> Table b:
> Col1 int
> col2 varchar
>
> can you have a single index for two tables a and b on the column Col1.
> Is this possible in SQL-Server.
>
> As far as i know you can make an index only on one Table.
>
> can the index be shared by two tables?
> index y which is created is shared by
> table a , table b and table c
>
> I like the idea of a union an putting it in a veiw and having a index
> but i dont want to make 100 views for a special index.
>
> first of all i want to know wether the index is only on one table can be
> on multiple tables.
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

> Can we make a Index on 2 or more tables
>
> Table a:
> Col1 int
> col2 varchar
>
> Table b:
> Col1 int
> col2 varchar
>
> can you have a single index for two tables a and b on the column Col1.
> Is this possible in SQL-Server.