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: 65143
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 Aug 18 15:25:08 CDT 2017

Total time taken to generate the page: 0.08550 seconds