Re: Optimum table and select

2001-09-01 Thread joseph . bueno
Hi, Edward Meyer wrote: > > I have a table with the following columns > id => int not null auto_increment > stockid => integer > tdate => date > price => float > primary key (id) > key (productid) > > The table has 8,000,000+ rows holding 8000+ different stockids. > > I have to pul

Optimum table and select

2001-08-31 Thread Edward Meyer
I have a table with the following columns id => int not null auto_increment stockid => integer tdate => date price => float primary key (id) key (productid) The table has 8,000,000+ rows holding 8000+ different stockids. I have to pull various information from the table the first que