Re: quick suggestions for tuning ?

Thanx a lot Tanel.

>select count(*) as cnt from profile where sex = ''j?«' and entpc
> = '192.168.15.1' and laccess between to_date('2003/08/08 00:00:
>00','yyyy/mm/dd hh24:mi:ss') and to_date('2003/08/08 23:59:59','
>yyyy/mm/dd hh24:mi:ss')
>Do you have index on "laccess" column for example?

Though there is index on "laccess" , it is not yet analyzed. none of the tables/index are analyzed yet.

Sorry,i should have told this earlier.
Since i'm working with a japanese client,communication is a huge barrier and convincing them is a HERCULEAN task :((

Let me do that first and get back to u.

Thanks and Regards,
Jp.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  INET: jprem_at_kssnet.co.jp

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).