List:General Discussion« Previous MessageNext Message »
From:Emanuel Alexandre Tavares Date:May 26 2003 1:52am
Subject:Re: Optimize this query...
View as plain text  
Ok Daniel,

Create a index with ID, AcountNo and Client.


Emanuel
São Paulo - SP
www.connix.com.br
www.jornalexpress.com.br
www.paginasdinamicas.com.br


>
> Ooooops.
> That query should have been:
>
> select ID, AccountNo, Client
> FROM CallData
> GROUP BY ID, AccountNo, Client
>
> The RSLCOMID field has just been renamed to ID...
>
> -- 
> Daniel Kasak
> IT Developer
> * NUS Consulting Group*
> Level 18, 168 Walker Street
> North Sydney, NSW, Australia 2060
> T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
> email: dkasak@stripped
> website: www.nusconsulting.com
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.483 / Virus Database: 279 - Release Date: 19/5/2003

Thread
Optimize this query...Daniel Kasak26 May
  • Re: Optimize this query...Daniel Kasak26 May
  • Re: Optimize this query...Dan Nelson26 May
  • Re: Optimize this query...Emanuel Alexandre Tavares26 May
  • Re: Optimize this query...Emanuel Alexandre Tavares26 May
    • Re: Optimize this query...Daniel Kasak26 May