OraFAQ Forum: SQL & PL/SQL » how can I optimize an sql with out using "distinct"????

Home » SQL & PL/SQL » SQL & PL/SQL » how can I optimize an sql with out using "distinct"????

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how can I optimize an sql with out using "distinct"???? [message #21800]

Sat, 31 August 2002 02:39

Prathee
Messages: 9
Registered: May 2002

Junior Member

hi all,
I have got a table
for example :
"table1" and 3 columns col1,col2,col3.
this table contains too many duplicate rows.

and not having any primary key fields.

insted of using
"select distinct col1,col2,col3 where col1>100"
can anybody suggest other optimized way(I mean insted of using "distinct" or "group by" in sql queries"

thanx in adv
-prathee

Report message to a moderator

Re: how can I optimize an sql with out using "distinct"???? [message #21846 is a reply to message #21800]

Wed, 04 September 2002 05:26

Su
Messages: 154
Registered: April 2002

Senior Member

A code example will make it clear. Please come back with your sample data. So that it would be easier to solve it. Good luck :)

Report message to a moderator

Previous Topic:	ora-4020 deadlock detected while trying to lock object:
Next Topic:	Wrap utility & performance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Oct 26 01:22:52 CDT 2025