Re: Bad optimization with two conditions?

Hi, On Sat, Mar 24, 2001 at 02:04:57PM +0100, Federico Giannici wrote: > Fred van Engen wrote: > > On Fri, Mar 23, 2001 at 07:46:48PM +0100, Federico Giannici wrote: > > > We have a table where we register the data of all the modem connections > > > of the users of a small ISP. > > > > > > The ta

Re: Bad optimization with two conditions?

Fred van Engen wrote: > > Hi, > > On Fri, Mar 23, 2001 at 07:46:48PM +0100, Federico Giannici wrote: > > We have a table where we register the data of all the modem connections > > of the users of a small ISP. > > > > The table contains 2 million records and has the following structure: > > > >

Re: Bad optimization with two conditions?

Hi, On Fri, Mar 23, 2001 at 07:46:48PM +0100, Federico Giannici wrote: > We have a table where we register the data of all the modem connections > of the users of a small ISP. > > The table contains 2 million records and has the following structure: > ... What indexes does the table have? Loo

Bad optimization with two conditions?

We have a table where we register the data of all the modem connections of the users of a small ISP. The table contains 2 million records and has the following structure: +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | E