Home » SQL & PL/SQL » SQL & PL/SQL » Selecting Distinct values (Oracle 10g, windows)
Selecting Distinct values [message #342447] Fri, 22 August 2008 06:46 Go to next message
Messages: 1
Registered: August 2008
Junior Member
I need to select distinct values on 40 columns in a table. The table has lakhs of records. Select distinct * takes quiet a long time. How can i optimize the query to make it faster to get results..
Re: Selecting Distinct values [message #342448 is a reply to message #342447] Fri, 22 August 2008 06:48 Go to previous message
Michel Cadot
Messages: 63956
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Previous Topic: Join query -- Is there a better way?
Next Topic: Default Foreign key setup
Goto Forum:

Current Time: Fri Oct 28 17:03:57 CDT 2016

Total time taken to generate the page: 0.06299 seconds