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 ??

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?

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 ??

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

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 ?

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.

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 !!

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?