Anthony,

You can pin the table into memory.

DBCC PINTABLE
Marks a table to be pinned, which means MicrosoftR SQL ServerT does not
flush the pages for the table from memory.

Syntax
DBCC PINTABLE ( database_id , table_id )

Thank you,

Sang
x6746


-----Original Message-----
From: anthony.[Email Address Removed] [mailto:anthony.[Email Address Removed] Wednesday, May 28, 2003 1:57 AM
To: LazyDBA.com Discussion
Subject: Fastest Table query.


Guys.
Here is some fun.

Whats the best way to make a table as quickly searched as possible. Apart
from just indexing the hell out of it.

Is it possible to load a table into memory?
If so, how would I do this?
__________________________________________
Anthony Hand
DBA | Systems Integration
Aon Risk Services Australia Ltd
Ph: +61 2 9253 7516
Fax: +61 2 92537952
Mob: +61 415 877 988



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page