on 09-21-2015 8:08 PM
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
If you don't specify a lock scheme when creating the table, the lock scheme is controlled by the server-wide sp_configure setting "lock scheme". You can change it to datarows with
sp_configure "lock scheme", 0, datarows
I don't think you can avoid either managing statistics or forcing indexes (or entire plans). One or the other needs attention for anything but the most trivial cases.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.