I have a table
create table Objects ( ObjectID bigint not null primary key, ObjectRef1 varchar(50) not null, ObjectRef2 varchar(50) not null, ObjectRef3 varchar(250) not null )
All fields are unique. The table has approximately 100 million rows. All columns have unique indexes, and are used frequently for queries.
What is faster? To normalize each of the varchar fields into seperate tables, or keep them as they are? If normalized, the table will only have the ObjectID column and ID's to the normalized tables, and I would do inner joins to get the values of ObjectRefX.
Should I consider other databases like Hadoop for this amount of data?