Title: Message
Hi list,
 
I issue a select count(*) from mytable and last 30 seconds.
 
The table has 1,466,196 records and were loaded with a batch process, so they are in a countinous space.
 
I consider that time exagerated.
 
The TBS is LMT with a Uniform size of 128 MB.
 
The block size is 8MB, version 9.2.0.1.0 in Windows 2000.
 
Where should I start looking ???
 
TIA
 
Ramon E. Estevez
[EMAIL PROTECTED]
809-565-3121
 

Reply via email to