Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
leanerking
Starting Member
2 Posts |
 Posted - 2011-04-13 : 10:21:25
|
Hi ,I have got following scenario bank, where i have to suitably choose index schema for bank operating in a single countryAccount ( 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 ?? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-04-13 : 10:35:53
|
| Absolutely no way to tell what indexes you need.Indexes are created to support the queries that run against the tables. Without info on what queries run, what columns are used for joins, what columns are filtered on, what columns are sorted by, there is absolutely no way to tell what indexes will be useful.--Gail ShawSQL Server MVP |
 |
|
|
leanerking
Starting Member
2 Posts |
Posted - 2011-04-13 : 12:04:16
|
| hi thanks for the reply , but not in programming scenario but for a general description or case can we choose some indexing schema considering perfomance factors , query answer time ,simplicity but more funtionality ?? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-04-13 : 15:59:30
|
| You cannot make any decision about indexing without knowing what queries execute against the table.If you want general: Create indexes to support the queries that run against the table. Anything else is a waste of time.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
|
|
Indexing Scheme which to choose ????