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..

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 03 05:06:46 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.