Submitted by: @pcisar
The ability to define/control the location of
this is pretty much an "over my dead body" issue. Much
I'm not sure but I think this would be usefull if you
1 file containing all objects and a 2nd file containing
The text was updated successfully, but these errors were encountered:
Commented by: Cosmin Apreutesei (cosmin_ap2)
I'd love to have the possibility to put some tables and indexes on a ramdrive device, others on a flash device and others on a hard disk, or I could use a compressed device for some big "archive" tables that I'd fill-up with a trigger.
Commented by: JJ Mondoloni (jjm)
I think that separate datas and index on different files and disks will be an best improvment.
By example, i have a big database (approx 18 go) with a big problem (page size 8192).
CREATE TABLE TB_URLS_HISTO (
/* Primary keys definition */
ALTER TABLE TB_URLS_HISTO ADD CONSTRAINT PK_TB_URLS_HISTO PRIMARY KEY (ID_SOURCE, URL_CRC);
/* Indices definition */
CREATE UNIQUE INDEX IDX_TB_URLS_HISTO_URC_CRC ON TB_URLS_HISTO (URC_CRC, R159_RPLID);
SET TERM ^ ;
Where URC_CRC and Id_SOURCE can be repeated and URL_CRC unique at 98%
Solution is easy, increase my page size.. but i have many table with hundred of thousand blobs
without increase my page size, i had some table with blobs filled at 2% (more modifications Insert / update / delete..)