delete takes too much time.

 ====Long time ago=============

Mark wrote:

> I have my app almost complete on MaxDB. I have just run 

> into a major snag 

> and would appreciate any help you can offer. 

> 

> I have a table "Files" that has about 400,000 rows 

> 

> If I run queries like 

> 1) SELECT * FROM FILES WHERE FILE_NAME = "THISFILE.TXT" 

> OR 

> 2) SELECT * FROM FILES WHERE FILE_ID = 687 

> 

> I get the results in a snap 

>