Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

On 15.5 onwards, does the standard temp tables created by ASE are DOL instead of ALLPAGES? (temp table issue)

Hi

Im looking for a way which i could use indexes on my temp tables without worrying about not having statistics or trying to force indexes.

The way i could find is to create the temp table as ALLPAGES and create a clustered index

Doing this way im sure that the leaves are the table's pages and so then they will be in the desired order (and i will save some index space...  a plus    )

What is bugging me is that i got the info that ALLPAGES tables do require more catalog locking effort than DOL tables. I did a quick look on the web and sybooks but i wasnt able to find more info....   It doesnt make sense to me, as naming and catalog efforts should be the same for both....

Does anyone have more info to share ? 

Thanks a lot!

Alexandre

Former Member
replied

I can't think of anything either, unless perhaps the source was actually talking about the greater levels of contention back when the system catalogs themselves all used allpages locking.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question