If you use regex combined with a where clause it can not use the index anymore. I think this is very important.