by Alex Kuznetsov <alkuzo@[EMAIL PROTECTED]
>
Jul 2, 2008 at 09:47 AM
On Jun 26, 3:12 pm, The Quiet Center <thequietcen...@[EMAIL PROTECTED]
> wrote:
> If I want to count the number of records in a table GROUPed BY the
> first word in a string column, must I first compute the first word and
> store in a tem****ary table and then do my GROUP BY select?
If you do that frequently, consider creating an index on a computed
column.