title: How to create index for dynamic search strings
body: <p>I have a little DB, for academic purpose only, and I have object tables at most.
  I've created a entity-relationship model (ERM) in Power Designer and the program, by default, creates index for the serial id's for each table.</p>
  
  <ol>
  <li>I want to know how do I use a index
  like that on a query.Say I would
  want to find a product by its id,
  but using its index.</li>
  <li>Is it possible to do <code>select
  value(s) from supplierf where s.name
  LIKE '%search%' order by s.name</code>
  using a index to do a search like
  that? I know it's possible to create
  index for the name, but for a search
  like that I don't know how things
  work.</li>
  </ol>
  
  <p>Let me say, that I do know that Oracle decides when or if it's worth using index in a query, but I may have to give, at least, a try on using indexs in my BD project</p>