Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2010

    Unanswered: Problem with distinct values

    Dear all,
    As a db grows fetching distinct values gets more and more time consuming. What is the best practice for solving this problem:
    1) Create separate tables for each columns of which distinct values are required
    2) Create one table with two columns: 1)name of the column and 2) multiple distinct values (Is it possible to store in a cell multiple values, such arrays etc)
    3) Do you know some more proficient solution?

  2. #2
    Join Date
    Jun 2011

    Hi ya matey

    I also came across the same problem of having slow distinct values,
    i don't know if this really could help you .

    see this link, about postgres tricks.
    PostgreSQL SQL Tricks - PostgreSQL

Posting Permissions

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