Text index of a field containing path in Oracle
<p>I have an Oracle table of which one of the columns contains text path to some element in a tree, for example "Node1/Node2/Node4/Leaf23". I would like to speed up the queries utilizing this column in its filters, especially using LIKE and % wildcard character (e.g. LIKE 'Node1/Node%'). Is there any mechanism in Oracle which could help me in this? Some sort of data type which will allow to treat these paths like something different than string? </p>

<p>When it comes to indexing I was thinking about Oracle Text, but I don't know if it will be performing well with this specific kind of short text strings - I believe Oracle Text was meant for some bigger and more complex texts.</p>