Home All Groups Group Topic Archive Search About
Author
18 Aug 2005 3:34 PM
Yosh
I have a SELECT INTO [#tmp] statement. Can I add an index to this temporary table after it  was created by the SELECT INTO?

Thanks,

Yosh

Author
18 Aug 2005 3:38 PM
David Gugick
Yes.

--
David Gugick
Quest Software
www.imceda.com
www.quest.com

"Yosh" <Yosh@nospam.com> wrote in message
news:O0IohpApFHA.2180@TK2MSFTNGP15.phx.gbl...
I have a SELECT INTO [#tmp] statement. Can I add an index to this
temporary table after it  was created by the SELECT INTO?

Thanks,

Yosh
Author
18 Aug 2005 3:41 PM
KH
Yes


Show quote
"Yosh" wrote:

> I have a SELECT INTO [#tmp] statement. Can I add an index to this temporary table after it  was created by the SELECT INTO?
>
> Thanks,
>
> Yosh

AddThis Social Bookmark Button