Hi All,
I need to implement a database hint so that the SELECT statement ALWAYS does a full table scan. That is, forcing a full table scan and not using any indexes.
Does anybody know how to do that and can provide an example here?
Thanks,
Johannes
Hi Johannes,
Hi All,
>
> I need to implement a database hint so that the SELECT statement ALWAYS does a full table scan. That is, forcing a full table scan and not using any indexes.
> Does anybody know how to do that and can provide an example here?
>
> Thanks,
>
> Johannes
since hints are database dependent we need to know the database plattform you are running on.
on ORACLE it would be:
%_hints ORACLE 'FULL("TABNAME")'
other databases have other hints...
Kind regards,
Hermann
Add a comment