Need help figuring out indexes for faster SELECT queries

2004-12-01 Thread Grant Giddens
I have a new project I'm working for and I was wondering if anyone could help me optimize my selects for speed. I have a table with about 500,000 entries. The table structure I'm using is (via my PHP commands): $sql = CREATE TABLE $store_data_table ( $store_data_column[sku]

Re: Need help figuring out indexes for faster SELECT queries

2004-12-01 Thread Roger Baklund
Grant Giddens wrote: I have a new project I'm working for and I was wondering if anyone could help me optimize my selects for speed. I have a table with about 500,000 entries. The table structure I'm using is (via my PHP commands): $sql = CREATE TABLE $store_data_table (