April 12, 2016 at 8:15 am
Hi,
I am optimising the indexes for a client and have come across a materialized view which has some 66 indexes which I'm looking to cut down to a reasonable number. Of these 66 indexes, 54 have the same naming convention, namely :
LB_IDX_xxxxxx_xxxxxx_<view_name>
where the x's are replaced by numbers.
The view has a full text catalog on one of its columns.
These indexes look as though they have been automatically generated by something, does anyone know what could have done this?
cheers
April 12, 2016 at 1:02 pm
No, I don't know what would have added those indexes. But I also don't see the relevance of that. Wouldn't normal index analysis -- of missing index stats, index usage stats, index operational stats, cardinality info, etc. -- be best to determine the indexes needed now?
I mean, I don't see how the existing indexes came to exist to be critical, although of course you need to search for any code that automatically creates indexes and disable it. At least the vast majority of the time, index adds/changes should be reviewed by a person rather than allowing automated code to do it.
SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!
April 13, 2016 at 2:37 am
Thanks for your reply Scott.
Yes, you're right of course, I will look at optimising the indexes based on the usage and other stats gleaned from the DMVs. I was just curious to know if there had been some tool used in the past which had created these.
April 14, 2016 at 10:00 am
ianharris2 (4/13/2016)
Thanks for your reply Scott.Yes, you're right of course, I will look at optimising the indexes based on the usage and other stats gleaned from the DMVs. I was just curious to know if there had been some tool used in the past which had created these.
Based on the naming of those indexes, I agree that these are likely prodiuced by a tool. However I have not seen this naming convention before and a Google search didn't give me any hits. Are you aware of any tools used in the past that fir the LB acronym?
Of course, it is also possible that these are simply the initials of a developer or DBA who liked to name indexes after him/herself. (I sometimes do this for objects I create to try something, so that I can quickly find which objects to drop when done. I would not use my initials in permanent object names).
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply