Want to Know the Reason
This is a discussion on Want to Know the Reason within the Oracle Database forums, part of the Database category; I recently heard from my friend that Distinct usage would reduce the performance of a query. But he could not ...
|
|||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
07-10-2007, 04:04 AM
|
|||
|
|||
Want to Know the Reason
I recently heard from my friend that Distinct usage would reduce the performance of a query. But he could not state the reason for the same when I asked for it. Can someone let us know why does Distinct usage would reduce the performance of a query.
    
|
| Sponsored Links |
|
10-24-2007, 10:01 AM
|
|||
|
|||
|
You have to sort the result set first to find the distinct values. However, you may lose nothing if there's a sort already for other reasons. You always may look into "explain plan" to see the difference, of course.
|
| Sponsored Links |
 |
| Thread Tools | |
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Kindly Provide the Reason | caradoc | Coldfusion | 0 | 01-14-2007 10:06 AM |
| Reason for Output | cyrus | C and C++ | 1 | 01-14-2007 10:02 AM |
| Kindly provide the Reason | Angela | Oracle Database | 2 | 12-28-2006 02:48 PM |
| Reason for the Choice of Operating System | Angela | Linux | 0 | 12-12-2006 03:19 AM |
| Need Technical reason | priyaraji | Coldfusion | 0 | 12-07-2006 12:46 AM |
All times are GMT -4. The time now is 12:18 AM.
