09-05-2013 5:10 AM
Hi,
I need to fetch
from the table tadir(Directory of Repository Objects) based on the created date(CREATED_ON ->field in tadir) .But the execution time is very high.Is it possible to reduce execution time?
09-05-2013 5:20 AM
Hi Kiran Rajan,
Can you share your code to know how you are fetching..
see this link for example http://wiki.sdn.sap.com/wiki/display/Snippets/ALV+report+to+list+the+user+developed+local+objects+in...
09-05-2013 5:28 AM
Hi Ramesh,
SELECT
pgmid
object
obj_name
author
devclass
created_on
FROM tadir INTO TABLE lt_tadir
WHERE created_on IN so_date.
so_date is select option.
lt_tadir ->internal table
09-05-2013 5:37 AM
Hi Kiran,
SELECT
pgmid
object
obj_name
author
devclass
created_on
FROM tadir INTO TABLE lt_tadir
WHERE created_on IN so_date.
i am not getting created_on in tadir table in my system
09-05-2013 5:58 AM
Hi Ramesh,
Can give any other table contain
09-05-2013 5:38 AM
Hi Kiran,
we have no CREATED_ON field in our systems in table TADIR.
But if you have one in your system, you can create a custom secondary index for that field. This should improve data access.
Regards,
Klaus
09-05-2013 5:55 AM
Hi klaus,
I try with secondary index but my data base system is maxdb.Is possible to use secondary index in maxdb
09-05-2013 6:01 AM
Hi Kiran
How you will fetch data with CREATED_ON field from TADIR, with out having that field in TADIR table.
if you fetch data using key fields i would be better.
09-05-2013 6:09 AM
09-05-2013 6:23 AM
09-05-2013 11:16 AM
Fields appended in SAP_BASIS 702, and yes no index on this field, so you fetch whole TADIR table (check your ehp level)
Regards,
Raymond
09-05-2013 8:14 AM
hi Kiran Rajan ,
if you add some extra necessary conditions to select statement then the execution time will reduce.
select
pgmid
object
obj_name
from tadir
into table it_dir
where date = s_date and devclass= '$TMP' and (obj_name like 'Z%' or obj_name like 'Y%') etc..
hope it will reduce the time span.
09-05-2013 10:40 AM
Hi Kiran,
As CREATED_ON is not a primary key at table level, so to have better improved performance and easy access to DB , just create one secondary index for CREATED_ON field, then use your select query.
Regards,
Sujeet
09-05-2013 1:18 PM
You may have to filter the records providing further selection criteria.
Example:
SELECT
pgmid
object
obj_name
author
devclass
created_on
FROM tadir INTO TABLE lt_tadir
where SRCSYSTEM NE 'SAP' and created_on IN so_date.
This will remove all the standard objects and will reduce the time considerably.
(That is if you are interested only in the user created objects )
09-12-2013 9:33 AM
Hi ,
Can you give any other table contain