SQL Query tuning

[tamilselvan]

SELECT category_id
FROM tcategory
START with category_id = 10
CONNECT BY PRIOR category_id = parent_id)

Do you have indexes on category_id and Parent_id?