# SQL hints and activerecord

**URL:** <https://www.ruby-forum.com/t/sql-hints-and-activerecord/135658>\
**Category:** Rails\
**Created:** [April 23, 2008, 10:52pm UTC](https://www.ruby-forum.com/t/sql-hints-and-activerecord/135658 "2008-04-23T22:52:02Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![divotdave](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/bbe5ce/32.png) [@divotdave](https://www.ruby-forum.com/u/divotdave)\
**Post date:** [April 23, 2008, 10:52pm UTC](https://www.ruby-forum.com/t/sql-hints-and-activerecord/135658/1 "2008-04-23T22:52:02Z")

</div>

How do I use SQL hints with ActiveRecord?

I’m trying to have “with(nolock)” added just before the “where”

Mytable.find(:first, :joins=\>‘with(nolock)’)

Gives the desired result, but I’d prefer to have it be a default.

Thanks!