Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
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 ...
|
|||||||
05-17-2007
|
|||
|
|||
|
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 |
|
08-06-2007
|
|||
|
|||
|
Re: Alternative for SELECT DISTINCT to query 2 million records
Try creating an INDEX for the table
|
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| difference bet unique and distinct | smitai | Oracle Certification | 4 | 3 Weeks Ago 08:35 AM |
| 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 |
| 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 05:46 PM.
