Temporary Indexes

• kasirisha

  Grasshopper

  Points: 15

  More actions

  May 11, 2011 at 10:15 am

  #1323210

  I am accessing a Event table which has huge volume of data. So I would like use temporary index in my Query.

  I cannot create additional index on the Event table without the permission of the Product owner.

  Please provide the syntax.

  Thanks in Advance for the help

• chrisfradenburg

  SSCrazy Eights

  Points: 9592

  More actions

  May 11, 2011 at 10:38 am

  #1323226

  kasirisha (5/11/2011)

  ---

  I am accessing a Event table which has huge volume of data. So I would like use temporary index in my Query.

  I cannot create additional index on the Event table without the permission of the Product owner.

  Please provide the syntax.

  Thanks in Advance for the help

  Temporary indexes aren't an official SQL entity like temporary tables are. It's created exactly like a normal index but is then dropped.