RE: should you seperate indexes from tables in seperate datafiles?

> It's hot here. I wish I was at the beach and I feel like an ant.

Hmmm.

> During an indexed query on a single table the index will be
> accessed, then the table, then the index,then the table,
> then the index,then the table then the index,then the table.

Assuming you get 4 rows returned :)

> If the index and the table are on the same disk then a lot of
> time will be taken up by head seek movement.
> If they are on the different disks then the "index" heads can
> locate their data and stay there - and the "data" heads can
> locate their data and stay there. Less head movement, less wasted
time.

I would understand this if I had one index and one table. On a busy system with many users wouldn't the heads move, anyway, to serve queries that used other indexes and tables? Received on Tue Jul 15 2003 - 10:07:31 CDT