Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2009
    Location
    islamabad
    Posts
    9

    Thumbs up Unanswered: how i come to know which colunm need index

    can any body tell me that i have many tables how i come to know wich table of wich colunm need indexing. is teher any query in 10g?

    regards
    shazia

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    as a general rule, all columns in WHERE clause should be indexed
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    and of course all foreign key columns

  4. #4
    Join Date
    Mar 2009
    Location
    New Delhi - India
    Posts
    22
    Index should be created based on your search condition in WHERE CLAUSE. For example, if ur using ROLLNO to search for student..
    Use of index is advisable if your query searches for less the 25% of the records.

  5. #5
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool Performance Tunning Guide anyone?

    Perhaps you should invest some of your time in actually reading the fine Oracle® Database Performance Tuning Guide
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  6. #6
    Join Date
    Mar 2008
    Posts
    14
    Hi,

    In simple terms - Use index for columns that are used frequently in WHERE clauses.

    But again there are many other conditions which decides whether Index is required or not. Would be good for you if you go through some 'Performance Tuning' documents.

Posting Permissions

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