I have all four tables analyzed. But CBO doesn't use index
on category_id column on TLISTING table. When I forced it
to use index, I am getting higher cost than FTS. I am worried that when table gets even bigger and more users are
on system, performance might degrade.

thanks for your reply