index HINT

• ksexton

  SSCrazy

  Points: 2790

  More actions

  June 28, 2002 at 10:44 am

  #57928

  For some reason the optimizer is not using my clustered index.

  I am trying to specify a HINT to force it to but have been unable to find the correct syntax.

  Table: CFT

  column= member_id

  index name= idx_mem

• Jeff W

  SSCertifiable

  Points: 5207

  More actions

  June 28, 2002 at 12:11 pm

  #431853

  SELECT <col1>, <col2>, etc..

  FROM <table1> WITH (INDEX(<idx1>))

  WHERE <condition clause>

  SELECT name

  FROM employee WITH (INDEX(idx_name))

  Hope this helps. I have run into problems where the hint causes an error with an ADO application.

  You may also want to update your statistics for the table with a sample of 50% and then try a FULLSCAN.

  
  "Keep Your Stick On the Ice" ..Red Green