Posting 2nd time Index Orgainzed
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Posting 2nd time Index Orgainzed

Hybrid View

  1. #1
    Join Date
    Jan 2000
    Location
    Arlington,VA,USA
    Posts
    11
    Hi

    We are trying to create a datamart by keeping all the
    tables as index organized, we started creating the
    tables and found that for Index Organized Primary
    key column is mandatory i.e you cannot create index
    organized table unless you have a column with unique
    values and a primary key on that column, any ideas
    why primary key is required, we also have some
    composite indexes on these tables since the tables
    reside in Index table space what will be the impact
    if we do not use the composite columns in a join
    in sequence i.e the way the composite index is created.
    anythoughts whether the query will use the index if
    we do not use the composite key in the order they
    have created.Please help as we are trying to do this
    to improve performance of our queries and we found
    in some instances that it is using 'Fast Full Index table
    scan hint' and the queries are faster and some cases
    they are not that effective.

    Thanks

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by greddy
    Hi

    We are trying to create a datamart by keeping all the
    tables as index organized, we started creating the
    tables and found that for Index Organized Primary
    key column is mandatory i.e you cannot create index
    organized table unless you have a column with unique
    values and a primary key on that column, any ideas
    why primary key is required,
    Thanks
    Why would you want to create an IOT without a primary key. See http://otn.oracle.com/docs/products/...chem.htm#11141 for concepts.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

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



Click Here to Expand Forum to Full Width