wht is query doing

[Former Member]

HI ,

please tell me wat exactly this query is fetching...am not able to understand the last line in the query

selcet f1,f2....fn

from table

where %_hints oracle 'INDEX ("T_00" "VBUK_{ZT1" "VBUK}ZT2")

index ("T_01" "VBAK_{0") INDEX ("T_02" "VBPA}0")

index ("T_03" "KNA1______0") INDEX ("T_04" "VBKD~0")'.

the above code was written in 2003 .

if we remove the above code (%_hints stmt), does it impact any performence issue?

regards,

dsk

[Former Member]

Hi kumar,

actually the % is used for character comparison. when we use % it means that any character may be there. if we do not use the '%' sign then the appropriate field in the table will not be found and data will not be fetched .

Hope this helps.

Please let me know about that.

Bye.

[Former Member]

The last line is an oracle hint.

It is meant to steer the SQL towards using a specific index when executing.

my question is if remove that stmt is there any performance issue?

[Former Member]

Hello

'%_hints' - this line send to optimizer which index wil be used in query (hard code use of index).

If you remove this string, that may be reduce performence issue. In any event, it is necessary to look code and indexes to tables.