Re: Sorting

Moshe wrote:
>
> Hi,
>
> How can I check if my table has indexes and also I would like to know index
> key ?

select index_name, column_position, column_name from user_ind_columns
where table_name = 'my table';

>
> I have a form.
> I used in pre-query trigger and when-radio-changed trigger and
> Set_Block_Property('Table',ORDER_BY, :Switches.Sort_Column);
> BUT it is very slow.
> How to impove it. I heard about "Hints" or something sounds like that, but I
> don't know what it is and how to use it.Is it good idea ?

Could be. Best action first would be to extract the SQL that your Form is issuing, and tune it. May be that an index on the 'Sort_Column' could speed up the form.

>
> Thanks in advance
> Regards Moshe

-- 
=====================================================================
Paul Harrington - Oracle DBA/Developer, Orbiscom, Dublin.
Email:  paulh_at_io.com. Please note: I discard all BCC messages unread.
=====================================================================