Hi,
Had a quick look around BOL and can't seem to find whether one can create an
index on a temp table?
Can anyone shed any light on this, please?
Cheers, SimonHi Simon,
You can create index on tem table. To view the information about index
please look into tempdb.
Regards,
Jagan Mohan
MCDBA
"SBeetham" wrote:
> Hi,
> Had a quick look around BOL and can't seem to find whether one can create
an
> index on a temp table?
> Can anyone shed any light on this, please?
> Cheers, Simon
>
>|||Ok, Cool... I can see the tempdb info... Thanks.
"Jagan Mohan" wrote:
> Hi Simon,
> You can create index on tem table. To view the information about index
> please look into tempdb.
> Regards,
> Jagan Mohan
> MCDBA
> "SBeetham" wrote:
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment