Results 1 to 2 of 2

Thread: Alternative for SELECT DISTINCT to query 2 million records

  1. 05-17-2007 #1
    Geek_Guest
    Guest

    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

    Reply With Quote Reply With Quote
  2. 08-06-2007 #2
    soorajsk_84
    soorajsk_84 is offline
    Junior Member
    Join Date
    Jun 2007
    Answers
    18

    Re: Alternative for SELECT DISTINCT to query 2 million records

    Try creating an INDEX for the table

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
GeekInterview
Interact