Hi I our database there is one table that will grow into tetrabytes within a short time. I would like to know how i can reduce full table scans. I have used separate tables as per region for now but the problem is if i create a new table i am forced to recompile the application. I can easily avoid this by using one table and an extra field to flag which region a paricular transaction happened.However i need ideas of how i can avoid full table scans because slow queries are unacceptable. it will also give me more flexibility in writing reports I will gladly appreciate any links that are specific to this problem and case studies.There people who need to be convinced
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
