I've a table where I store URL and It's download HTML so far there are total 8 lac rows in this table but the performance of select query is very poor. If i execute following query it takes several minutes to return result.
SELECT * FROM html_table WHERE url = "http://www.mydomain.com/mypage/"
Please let me know what should i do to prevent such issues? I've created index on url column the performance is now somehow better! but is this the viable solution? to put index on varchar type of column?
Please let me know what should i do to prevent such issues? I've created index on url column the performance is now somehow better! but is this the viable solution? to put index on varchar type of column?
0
