Hi Experts, I have a table which stores domain and its url s .All the urls in the table are distinct.I have a column which stores md5 hash of that url and have a nonclustered index on md5 hash. The problem is the distinct urls which are inserted in this table are very high in number.The table already has 100 million urls.We are also using this table for reporting.It also cannot be partitioned(as on what basis should it be partitioned). The table structure is somewhat like this id bigint ,domain_name varchar,url nvarchar(max),md5_hash varchar Can this data be stored more efficiently as querying such a large table takes a lot of time. Any advice will be highly appreciated
Welcome to the forum! The decision on how to store the data is a fundamental decision is the whole application design process. We know far too little about the whole requirements to suggest anything useful. Depending on what your reporting requirements are, if might be worth transferring the data to some kind of datawarehousing data storage.
