Hi Sean,

Thanks for your reply. I did it, and you are right - selectivity is much better.
But, what is not better is query execution time.

Here are new data:

Query
------------------------------------------------
select distinct
articles.art_id,
articles.art_article_nr,
generic_articles.ga_id,
link_art.la_id,
link_la_typ.lat_sort sort,
link_la_typ.lat_sup_id bra_id,
articles.art_replacement
from link_la_typ
inner join generic_articles on lat_ga_id = ga_id
inner join link_art on lat_la_id = la_id
inner join articles on la_art_id = art_id
where lat_typ_id=:TYP_ID  and ga_id=:GA_ID
ORDER BY 7 ASC
       , 2 ASC

Plan
------------------------------------------------
PLAN SORT (SORT (JOIN (GENERIC_ARTICLES INDEX (GENERIC_ARTICLES_IDX1), LINK_LA_TYP INDEX (LINK_LA_TYP_IDX5), LINK_ART INDEX (LINK_ART_IDX1), ARTICLES INDEX (ARTICLES_IDX1))))

Query Time
------------------------------------------------
Prepare       : 31.00 ms
Execute       : 4,789.00 ms
Avg fetch time: 228.05 ms

Memory
------------------------------------------------
Current: 10,273,304
Max    : 129,710,544
Buffers: 2,048

Operations
------------------------------------------------
Read   : 3,049
Writes : 0
Fetches: 3,794
Marks  : 0

Tables now return:

ARTICLES - 79 indexed reads
GENERIC_ARTICLES - 1 indexed read
LINK_ART - 79 indexed reads
LINK_LA_TYP - 79 indexed reads

Any ideas other ideas ?

Regards,

Zoran