# Adding a hint in filter definition

**URL:** <https://forums.toadworld.com/t/adding-a-hint-in-filter-definition/39468>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [May 16, 2017, 2:10am UTC](https://forums.toadworld.com/t/adding-a-hint-in-filter-definition/39468 "2017-05-16T02:10:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [May 16, 2017, 2:10am UTC](https://forums.toadworld.com/t/adding-a-hint-in-filter-definition/39468/1 "2017-05-16T02:10:13Z")

</div>

Hi is there any way to add a hint in filter (from grid) to get better execution performance.  
I.e  
select **/\*+ PARALLEL(SQL\_PERF\_FROM\_HIST, 2) \*/**  
MONITORED\_DATE,  
MODULE,  
SQL\_ID,  
NR\_EXECS,  
ELA\_SECS,  
AVG\_EXEC,  
NR\_ROWS,  
AVG\_ROWS,  
NR\_LOG\_READS,  
AVG\_LOG\_READS,  
PARSING\_SCHEMA,  
SQL\_TEXT,  
DESCRIPTION,  
WINDOW  
FROM Q383211.SQL\_PERF\_FROM\_HIST  
WHERE 1 = 1  
ORDER BY MONITORED\_DATE DESC,  
AVG\_EXEC DESC  
instead of originally generated:  
select  
MONITORED\_DATE,  
MODULE,  
SQL\_ID,  
NR\_EXECS,  
ELA\_SECS,  
AVG\_EXEC,  
NR\_ROWS,  
AVG\_ROWS,  
NR\_LOG\_READS,  
AVG\_LOG\_READS,  
PARSING\_SCHEMA,  
SQL\_TEXT,  
DESCRIPTION,  
WINDOW  
FROM Q383211.SQL\_PERF\_FROM\_HIST  
WHERE 1 = 1  
ORDER BY MONITORED\_DATE DESC,  
AVG\_EXEC DESC

Brg  
Damir

---

<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:** [May 16, 2017, 6:03am UTC](https://forums.toadworld.com/t/adding-a-hint-in-filter-definition/39468/2 "2017-05-16T06:03:30Z")

</div>

Where in Toad is that query generated? I don’t recognize it.

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [May 16, 2017, 6:09am UTC](https://forums.toadworld.com/t/adding-a-hint-in-filter-definition/39468/3 "2017-05-16T06:09:29Z")

</div>

Sorry for not be clear.  
I want to add a hint somehow and normally, there is none in Toad like that.  
Hope now is more clear.

Brg  
Damir

---

<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:** [May 16, 2017, 6:09am UTC](https://forums.toadworld.com/t/adding-a-hint-in-filter-definition/39468/4 "2017-05-16T06:09:33Z")

</div>

If you are using the Schema Browser Data tab’s filter, then no, there’s no way to add a hint from that window (not a bad idea). But you can click the VIew/Edit query button and add the hint there. In the beta, you can name and save your edited query for easy recall later. Details here: [https://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2016/12/23/named-queries-in-sb-tables-data](https://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2016/12/23/named-queries-in-sb-tables-data)