Re: index vs fts

I think you missed the '+' symbol while specifying the hint ; It should be /*+ full(PS_JOB) */ ;

HTH
GovindanK

Joe Armstrong-Champ wrote:
> I have a performance problem with a query since upgrading to 10.2.0.3
> from 9.2.0.7 (OS is aix 5.3). I ran a 10046 trace through tkprof and
> it shows index access on a table which accounts for most of the table
> (ps_job). So I thought that I'd force a fts using a hint. The sql is
> selecting from a view so I put the hint everywhere the table is
> selected. I also tried putting the However, it doesn't change the
> access path for the table.
>
> I have also been researching and trying different things for the merge
> join cartesian to no avail.
>
> Any ideas appreciated. Thanks. Joe
>
> main sql:
> SELECT DISTINCT EMPLID, EMPL_RCD, NAME, LAST_NAME_SRCH, NAME_AC,
> PER_STATUS FROM JOE
> WHERE ROWSECCLASS='TAXES' AND LAST_NAME_SRCH LIKE 'THIB%'
> ORDER BY LAST_NAME_SRCH, EMPLID, EMPL_RCD
>
> view:
> select /* full(PS_JOB) */
> 3 A.EMPLID ,JOB.EMPL_RCD ,SEC.ROWSECCLASS ,SEC.ACCESS_CD ,A.NAME

--
http://www.freelists.org/webpage/oracle-l