Home » SQL & PL/SQL » SQL & PL/SQL » how can I optimize an sql with out using "distinct"????
how can I optimize an sql with out using "distinct"???? [message #21800] Sat, 31 August 2002 02:39 Go to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 13:37:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.