Hi All ,
I have one table which holds history weekly history data, each week has records about 100000 records. Now i have to use reporting tool(cognos in my case)
to create report which will use this table and we have to compare data between two dates.
Now each table record can be uniquely identified by using candidate key on two colums : ID,VIEW_DATE.
View date is is the snapshot date.
Currently no primary key,index etc. is defined on the table. I am very new to database ..please suggest me if i need to create primary key/index and will it help in read(select query)
My most of the calculations will be like count(id) for one period for certain where clause filter and compare similar count for difference snapshot date.
Kindly advice/suggest. Thanks!