ESO Archive Frequently Asked Questions

When I use the wild-card on some queries (e.g. Filter: R*), the results take much longer to show up. Why?

The speed of completion for a given database query may vary depending on the amount of data to be searched and whether or not the database server uses the indexes associated to it. Under some conditions (specially when using wild-cards), these indexes are ignored and the server scans the complete database. Since the ESO databases tend to be large, scan times of up to a minute can be expected.