subject:"Large query techniques"

RE: Large query techniques

2003-09-02 Thread Dan Greene

queries... > -Original Message- > From: Stephen McMullan [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 02, 2003 12:59 PM > To: [EMAIL PROTECTED] > Subject: Large query techniques > > > Assuming that I had a database containing a single table used > to

Large query techniques

2003-09-02 Thread Stephen McMullan

Assuming that I had a database containing a single table used to record an audit trail of messages originated from customers and their applications like so: CREATE TABLE `LogMessage` ( `MessageID` int(11) NOT NULL auto_increment, `CustomerName` varchar(100) default '', `ApplicationName` var