Statement does not reference any tables

• Muralidharan Venkatraman-417748

  Mr or Mrs. 500

  Points: 546

  More actions

  July 2, 2008 at 1:19 pm

  #194610

  I have collected a workload trace and ran it agains the tuning advisor and i keep getting these 2 messages:

  1. Statement does not reference any tables

  2. Event does not reference any tables

  Can someone throw some light on it?

  Thanks

  Murali

• GSquared

  SSC Guru

  Points: 260824

  More actions

  July 2, 2008 at 2:18 pm

  #837489

  You have a proc/script in your trace that doesn't select/update/insert/delete anything in any tables.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon