If the indexes aren't being used then you are probably safe to delete them. However if they are being used at all then your performance will suffer when those queries are run if you remove the indexes. Boolean columns are typically useless to index unless it's the last column in the list of columns in the index. As Boolean columns (BIT datatype) have only two options if an index contains only a Boolean column the index won't be of much use as the index will need to be scanned almost every time. If your indexes are 80GB running a single nonindexed query against the database will take a lot of CPU and disk resources to process. When deciding to remove an index you need to weigh the cost of the index against the cost of running the query or queries without the index. Which ever one costs less is the right method to use.

If the indexes aren't being used then you are probably safe to delete them. However if they are being used at all then your performance will suffer when those queries are run if you remove the indexes. Boolean columns are typically useless to index unless it's the last column in the list of columns in the index. As Boolean columns (BIT datatype) have only two options if an index contains only a Boolean column the index won't be of much use as the index will need to be scanned almost every time. If your indexes are 80GB running a single nonindexed query against the database will take a lot of CPU and disk resources to process. When deciding to remove an index you need to weigh the cost of the index against the cost of running the query or queries without the index. Which ever one costs less is the right method to use.