# RE:  Stop Toad from loading blobs

**URL:** <https://forums.toadworld.com/t/re-stop-toad-from-loading-blobs/9753>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [August 10, 2010, 10:58am UTC](https://forums.toadworld.com/t/re-stop-toad-from-loading-blobs/9753 "2010-08-10T10:58:46Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [August 10, 2010, 10:58am UTC](https://forums.toadworld.com/t/re-stop-toad-from-loading-blobs/9753/1 "2010-08-10T10:58:46Z")

</div>

So one option prevents them from being queried at all, and the other prevents  
the lob from being queried initially but can be brought in as needed?

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [August 10, 2010, 11:26am UTC](https://forums.toadworld.com/t/re-stop-toad-from-loading-blobs/9753/2 "2010-08-10T11:26:22Z")

</div>

“Don’t select” leaves it out of the select statement entirely.

‘Deferred lob read’ and ‘Preview Clob and Long data’  
controls when the fetch of lob data happens. If you hover your mouse over the  
options, it will tell you which is fasted (checked or unchecked). I can’t  
remember it off the top of my head. Also, there was a bug in 10.5 that caused  
‘preview’, when unchecked, to fetch more data than it needed to.  
This is fixed in 10.6.