DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Clustering !!!!!!!!!!!!1

  1. #1
    Join Date
    Jan 2002
    Posts
    22
    Can u tell me how clustering the tables and indexes help in improving performance for oracle 8i?


    Regards
    Rajesh C.Makwana
    When things go wrong and u feel sick , Rest if u must , but Do not quit....

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Tables clustering is used on tables which are frequently joined using equi join.Indexes are used for faster data reterival and indexes are done based on the type of application used.If runing oltp use b-tree,if using dss use bitmap index.Indexes should be created on those colums which are frequently used in the where clause and should have higher cardinality.


    cheese
    anandkl
    anandkl

  3. #3
    Join Date
    Jan 2002
    Posts
    22

    Clustering!!!!!!!!!!1

    Hi,
    I am asking about the clustering index?????

    Is it really improve the performance in Oracle8i???

    Regadrs

    Rajesh C.Makwana
    When things go wrong and u feel sick , Rest if u must , but Do not quit....

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    I doubt that they realy improve the performanc, since there is no such type of index in Oracle. Clustered indexes exist in some other relational databases, but not in Oracle. The only "clustered" database object available in Oracle are clustered tables, as you were allready told.

    Also, could you be a little more specific about your actual problems in the future? For such a broad questions probably the best answer you will get here will be links to Oracle documentation. But you can probably find and searc the documentation yourself, I guess.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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