Hi there

Try this:

A) use no lock hints when quering the table
B) table doesn't change often (or very rarely?) - consider a in memory
cache obj globally accessible to the app
C) single covering index
D) take care with wrappering the call in a com+ transaction (if applicable)

Cheers

Ck

-----Original Message-----
From: sang.[Email Address Removed] [mailto:sang.[Email Address Removed]
Sent: Wednesday, 28 May 2003 7:19 PM
To: LazyDBA.com Discussion

MS Sql Server LazyDBA home page