Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    22

    Unanswered: Rowids in fragmented table

    Hello All,

    Does fragmneted table contain rowids?
    If not, how to find the duplicate rows in a table?

    I am trying all my ways and nothing is working.

    Please help!!


    -PD

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: Rowids in fragmented table

    Originally posted by pd12
    Hello All,

    Does fragmneted table contain rowids?
    If not, how to find the duplicate rows in a table?

    I am trying all my ways and nothing is working.

    Please help!!


    -PD
    Hi,

    All the rows continene rowid and is not repeated.
    In fragmented tables, if it can be repeated, single rowid, not it row. In order to look for duplicated rows rowid executes:
    for example select rowid, (primary key),count(*)
    from table
    group by 1,2
    having count(*) > 1

    Warning: Informix recommends not to use rowid in fragmented tables.

    Gustavo.

  3. #3
    Join Date
    Sep 2003
    Posts
    22
    Hello Gustavo,

    Thank you, so much.
    I got it.

    -PD

Posting Permissions

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