Home » SQL & PL/SQL » SQL & PL/SQL » Opinions on using distinct / unique
Opinions on using distinct / unique [message #460] Thu, 14 February 2002 00:21 Go to next message
Dan
Messages: 61
Registered: February 2000
Member
Does anyone have an opinion on using 'select distinct value from table' as being particularly bad practice.

Is there any other way to do it which is better?

TIA

Dan
Re: Opinions on using distinct / unique [message #464 is a reply to message #460] Thu, 14 February 2002 04:01 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
it totaly depends on your requirement.if u can afford non-distinct , then netter go for it, as sorting overhead will be avoided
Re: Opinions on using distinct / unique [message #478 is a reply to message #460] Thu, 14 February 2002 23:06 Go to previous messageGo to next message
Abul Fazal
Messages: 39
Registered: February 2002
Member
What is the problem do u think arises b'cos of using Distinct. Can u make u'r thoughts a little bit more clear.
Re: Opinions on using distinct / unique [message #481 is a reply to message #460] Thu, 14 February 2002 23:37 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
the use of distinct invoke a sort and sorting is expensive and so the use of distinct
Previous Topic: improving performance of a query
Next Topic: Re: how to display only limited no of rows at a time
Goto Forum:
  


Current Time: Fri Sep 24 15:17:13 CDT 2021