I would like to be able to index the Url field of the html table to do like searches on paths. Right now I have a metamorph index on the field but the performance is slow.
The table size is about 250k rows. Return sets can be in the thousands but are usually under 500. We have 1 GB RAM on Solaris 2.9, 440 mhz CPU.
An example of a typical query is:
SELECT Url FROM html WHERE Url LIKE 'www.foo.com/health/*/women'
Is there anything I can do to make this query run faster?
Joel
The table size is about 250k rows. Return sets can be in the thousands but are usually under 500. We have 1 GB RAM on Solaris 2.9, 440 mhz CPU.
An example of a typical query is:
SELECT Url FROM html WHERE Url LIKE 'www.foo.com/health/*/women'
Is there anything I can do to make this query run faster?
Joel
