Query/Index (Force it)

• saulo benigno

  SSC Journeyman

  Points: 86

  More actions

  May 3, 2005 at 4:35 pm

  #362524

  ok.. i'm a index newbie.. got it working today (2 weeks after working with sql server)

  so.. how can i do a select forcing to use one index that i want ?

  select ?!

  thanks

  btw, sql 7.0

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  May 4, 2005 at 3:57 am

  #556705

  Please avoid posting the same question to multiple fora. Keep the thread here:

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=179647

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• saulo benigno

  SSC Journeyman

  Points: 86

  More actions

  May 4, 2005 at 9:06 am

  #556796

  sorry, can you close it ?

  thanks