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 |
|
testac
Starting Member
3 Posts |
 Posted - 2009-10-22 : 12:22:58
|
| Hi ,I would like somebody to suggest me the Index to use in my scenario -My Table gets Files uploaded by bcp daily once consisting of total 50K records and my search on these tables to be display data on front end is on fields which are not unique ields like Business date or on Classification which are only 6 in 50K recs ie 50K recorde are classified within 50K recs. I have to fetch all rec for a given date ie approx 50K recs or fetch data for a classification(approx 10K recs).So in this scenario kindly suggest me the Index (if any) which can be applied to this table.Points: 1. Search is majority on either of 2 fields mentioned above and whole data has to be fetched .2. Data is uploaded to table once during day and no updates on recs of tables , only search is done.3.My datasets within 3 weeks can touch 1 million recs.4.around 119 cols in a table and i don't think i can split that as feed files comes with that many cols and will be problem while bcp.So Table: 119cols , daily 50K recs and search on to fetch 50K from 1 million recs So please suggest ways to increase on performance as data fetch from 1 million recs is taking 22secs.Thanks in advance |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-10-22 : 15:36:44
|
| Is there a date indicating when the row was added to the table? Would it be possible to partition your table by date inserted?Mike"oh, that monkey is going to pay" |
 |
|
|
testac
Starting Member
3 Posts |
Posted - 2009-10-22 : 22:04:00
|
| Important Date for me is when business happened rather than when row was inserted so what date is in data file i have to search on that basis.By partitioning on business date ?By the way one important point, my DB is Sybase ASE 12.5.4Thanks in advance |
|
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-10-23 : 11:07:56
|
| Ugh. Sybase. My usefulness to you ends here then. Hopefully someone else can help you.Mike"oh, that monkey is going to pay" |
|
|
|
|
|
|
Which Index to be used