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

    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?
    Thanks

  2. #2
    Join Date
    Jun 2011
    Posts
    1

    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
  •