ALTER INDEX X_3 ON T_PERSONNE_PRS REBUILD WITH(DATA_COMPRESSION = PAGE).ALTER INDEX X_2 ON T_PERSONNE_PRS REBUILD WITH(DATA_COMPRESSION = PAGE).ALTER INDEX X_1 ON T_PERSONNE_PRS REBUILD WITH(DATA_COMPRESSION = PAGE). ALTER TABLE T_PERSONNE_PRS REBUILD WITH(DATA_COMPRESSION = PAGE).We have compressed tables and index in SQL Server (there is no compression in PostGreSQL): Performances of COUNT with indexes and compression: PostGreSQL has nearly no gain or loss with or without index… SQL Server is worst with indexes for queries 5, 6, 7, but the loss is also very few. SQL Server is better with indexes for queries 2, 8, 9, 10 but the gain is very few. PostGreSQL is between 7 and 561 times slower than SQL Server for COUNT with appropriate indexes. CREATE INDEX X_3 ON T_PERSONNE_PRS (PRS_NOM, PRS_PRENOM).CREATE INDEX X_2 ON T_PERSONNE_PRS (PRS_PRENOM).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |