When one talks about "pinning" in indexes, what exactly is this? Is there some other word/term I can search for, as google has not provided any solutions. It is part of a test question, where ...
I need to add some indexes to a moderately large table and I'd like to know in advance if the tablespace has room to hold the index. (The extents are suppose to automatically increas in size, but the ...