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
svijjay
Messages: 1
Registered: August 2008
Junior Member
All,
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: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

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


Current Time: Sat Dec 10 02:46:03 CST 2016

Total time taken to generate the page: 0.07870 seconds