To run only a portion of a large SQL or PL/SQL query in TOAD, you can press Shift+F9 to run the specific part of the query situated at your cursor. This feature allows you to see intermediate output or the output of inner queries easily, and is particularly useful for debugging purposes.