Unanswered: indexes on temp tables inside procs - are they used?
I always remember sybase would never use an index created on a temp table within a stored procedure. This seems to have changed recently but the online sybase docs still state that these indexes won' be used. I'm a bit confused. Has it changed recently? are the online sybase docs wrong? or are there certain conditions to be met before these indexes are used?
The index is definitely being used - it says it is in the showplan and the performance indicates it's being used. My issue is simply that the docs clearly state that these indexes are not used and this was certainly the case before. I just wondered what had happened and why sybase weren't advertising the fact that these indexes are now used. Just seems odd.
Since I cant paste the content as it may be against copyright laws, basically it says indexes can be picked but its not guaranteed and its better to separate creation / usage and hence the docs wont be updated.
Now, it will be interesting to know in what cases that is infact true.