Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Large volume of data

Go to solution
itabhishek9
Participant

‎2010 Sep 24 11:08 PM

0 Kudos
113

Hi SDnites,

I have to write a query on a table which has huge volume of data and also we do not have all the keys which will help me in better searching. We have thought of creating a secondary index on the table but agin that is negated as it will put extra burden on database. Please suggest the alternative options which are good in this scenario.

Abhi

1 ACCEPTED SOLUTION

Go to solution
brad_bohn
Active Contributor

‎2010 Sep 24 11:32 PM

0 Kudos
61 
but agin that is negated as it will put extra burden on database

Why do you say that? If you create a good/specific index, what's the burden? Certainly it's not a storage limitation?

2 REPLIES 2

Go to solution
brad_bohn
Active Contributor

‎2010 Sep 24 11:32 PM

0 Kudos
62 
but agin that is negated as it will put extra burden on database

Why do you say that? If you create a good/specific index, what's the burden? Certainly it's not a storage limitation?

Go to solution
samantak_chatterjee
Active Contributor

‎2010 Sep 26 2:02 PM

0 Kudos
61

Hi,

If you can have some of the keys, you can atleast create some local buffering with those in the ABAP Program. This will help you to reduce the number of accesses to the Database. And also, this will keep the number of the Data Access to be minimal. You can also take into account of using some of the Performance Improving factors like Field Symbols.

Hope this will help.

Thanks,

Samantak.