On 15.5 onwards, does the standard temp tables created by ASE are DOL instead of ALLPAGES? (temp table issue)
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!