Select * from sysobjects where xtype = 'u' Option (fast 1) SELECT * from sysobjects where xtype = 'u'
Adding Option (FAST 1) Options can be upgraded for a few times