Results 1 to 8 of 8
  1. #1
    Join Date
    Apr 2011
    Posts
    17

    Exclamation Unanswered: Which indexing scheme to choose from ??



    Hi ,

    I have got following scenario

    Customer ( with acctno,branchno,etc 10 subfields)
    Branch ( branchname,town ,etc 8 subfields)
    Employee ( empname,empaddr, 6 subfields)
    Customer (Custname,custaddr,6 subfields )

    So can any one suggest exactly which type of indexing scheme I should choose for above scenario and why it would be usefull , I am confused after seeing all indexing schemes which one to choose ??

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by learnerkid View Post
    eek eek mad mad
    i echo that sentiment

    first of all, indexes are absolutely useless (in fact, worse) for storing data

    indexes are only useful for optimizing retrieval queries, and you haven't shown us any retrieval queries

    secondly, you have only one (apparent) foreign key in your four tables -- several don't seem to be related at all!!

    also, you have two tables with the same name, a definite no-no in database design


    helps?

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Apr 2011
    Posts
    17
    Hi ,

    I have got following scenario ( corrected one )

    Account ( with acctno,acctype,etc 10 subfields)
    Branch ( branchname,town ,etc 8 subfields)
    Employee ( empname,empaddr, 6 subfields)
    Customer (Custname,custaddr,6 subfields )

    So can any one suggest exactly which type of indexing scheme I should choose for above scenario and why it would be usefull , I am confused after seeing all indexing schemes which one to choose ??

    Note:: I have corrected the requirement but I have to implement a indexing schema pls suggest ??

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by learnerkid View Post
    ... but I have to implement a indexing schema pls suggest ??
    i suggest you read my previous reply, regarding queries

    indexing schemes cannot be designed in a vacuum

    if your homework assignment did not mention queries, you're taking a very poor course
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Apr 2011
    Posts
    17
    Hi ,

    I was trying to learn concepts of Indexing on my own along with how to implement it for certain scenarios one of these was above banking one where i have to suitably choose index schema for bank operating in a single country , which schema to choose was really confusing , I respect your answer for the question !! ,Please Can I whether ask is it impossible to choose indexing schema for above scenario if we keep other factors which are off course better options than indexing apart ?

  6. #6
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Quote Originally Posted by learnerkid View Post
    Please Can I whether ask is it impossible to choose indexing schema for above scenario if we keep other factors which are off course better options than indexing apart ?
    If you don't have any queries, you don't need indexes.

    Indexes are only there to support SELECT, DELETE or UPDATE statements.

    If you don't know which statements you are going to execute, you can't say which indexes you need.

  7. #7
    Join Date
    Apr 2011
    Posts
    17
    I want to just decribe how particular Index schema suits the banking scenario described above it just clarifies your index understanding but I am confused which of them is quite suitable for it regarding perfomance wise , time wise etc !!

  8. #8
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i'm not sure if you're listening, because we've told you several times

    an indexing scheme without reference to the queries that it has to support is useless

    if you don't post the queries, we don't tell you the indexing scheme

    got it now?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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