Hi, I'm learning MySQL and I got two question:
1) As I know, MySQL has a buffer to keep the last records which have been retreived. So if I run a query two times, the second time will be faster. How can I temporarly stop this service? because I want to run different queries and compare their speed and find the best solution for a problem. 2) A table has 2 fields, Active CHAR(1), and Company CHAR(40). Sometimes I want to search a company name and sometimes I want to search an active company. For faster searching, do I need to create two index like these: CREATE INDEX active ON customer (CONCAT(active, company)); CREATE INDEX company ON customer (company); If I create just the first index, do I still have a fast searching on company name ( without mentioning Active )? like this: SELECT * FROM customer WHERE company = 'my test company'; Thanks
