Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Alternative for SELECT DISTINCT to query 2 million records

This is a discussion on Alternative for SELECT DISTINCT to query 2 million records within the SQL forums, part of the Databases category; My table has 2 million records. I want to select distinct values from the table. If I use select distinct... it may take more time. What would be another option ...

Geeks Talk > Databases > SQL Alternative for SELECT DISTINCT to query 2 million records

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   05-17-2007

Geek_Guest Expert Member   Join Date: Feb 2007 Posts: 1,279 Thanks: 0 Thanked 164 Times in 138 Posts

Alternative for SELECT DISTINCT to query 2 million records My table has 2 million records. I want to select distinct values from the table. If I use select distinct... it may take more time. What would be another option to select distinct values in less time. Question asked by visitor Ankush

Sponsored Links

#2 (permalink)   08-06-2007

soorajsk_84 Junior Member   Join Date: Jun 2007 Location: Bangalore Posts: 18 Thanks: 0 Thanked 0 Times in 0 Posts

Re: Alternative for SELECT DISTINCT to query 2 million records Try creating an INDEX for the table

Geeks Talk > Databases > SQL

« hirerichal type database in SQL | Query »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SELECT query processing	althafkarkal	Database General	5	08-09-2007 05:59 AM
Insert of multiple records in single query	ramvidhu	SQL Server	5	07-03-2007 08:53 AM
difference bet unique and distinct	smitai	Oracle Certification	2	06-18-2007 04:00 AM
Updating 10 million rows	madivals	Oracle	3	05-11-2007 10:58 AM
Alternative to EJB	JobHelper	Java	1	11-29-2006 01:49 AM

All times are GMT -4. The time now is 01:43 AM.