Sure an index can be larger. A lot of what is going on is DB and optimizer dependant. As long as it makes your query faster, that is all that usually matters.
I'd say drop any indexes you can and recreate them after the import.
__________________
"The problem with any ideology is that it gives the answer before you look at the evidence."
—Bill Clinton
"The greatest obstacle to discovery is not ignorance--it is the illusion of knowledge."
—Daniel J. Boorstin, historian, former Librarian of Congress
"But the Senator, while insisting he was not intoxicated, could not explain his nudity"
—WKRP in Cincinatti
|