I am thinking of setting up a test environment running SQL Server 2000 to run digital video storage systems. What type of index is supposed to be placed on such table? I was thinking of using full-test index that can be used for tables that have few columns and contain static data right? I need to know what index I must use. I shall remain.

Regards,

__________________
CarlWalden

Indexes are just to speed up queries. Ideally, you need to index those columns that:
a) are queried often (each primary key fields)
-and-
b) have a low degree of similarity (ie most values are unique)

Indexing binary content is a waste of time, as far as I can tell, since you can't place binary criteria in your SQL statements...

Cheers
Ken

www.adOpenStatic.com

Ken,

Thanks for your advice that was what I thought couple of days back but I am not 100% sure and now I know what is expected of the DB. Thanks once again and have agood.

Regards,

Walden,
We are working on the picture archiving system (PACS), I explain you the way we do it. We save all images in the file system and have a little table to control their locations. In that table we have only two fields StudyID and FilePath, where table is indexed on StudyID. All our enquiries are based on the StudyID.
-ned

-Ned