i use ms sql 2000 server
the customerprofile table i used grow rapidly , i need to scrub data in this table and search regularly by phone and customerid. i have used two index for phoneno and customerid seperately, but query execution is still very slow. shrinking database is placed as a part of maintenance plan. how do i make it fast?
is it possible using custom tablespace size in our choice ?