Bugs item #1997434, was opened at 2008-06-19 04:55 Message generated for change (Comment added) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1997434&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. >Category: SQL/Core Group: None >Status: Closed >Resolution: Invalid Priority: 5 Private: No Submitted By: David Wung (fivecolor) >Assigned to: Niels Nes (nielsnes) Summary: SQL: Index is of no effect Initial Comment: When i did TPC-H test, it seemed index doesn't work. repeat step: 1. create tables by file 'c.sql-dec-primary' below 'MonetDB-SQL/sql/src/benchmarks/tpch' 2. generate data by 'dbgen' below 'MonetDB-SQL/sql/src/benchmarks/tpch/dbgen'. eg. './dbgen -s 1' 3. execute 'run.all' below 'MonetDB-SQL/sql/src/benchmarks/tpch', and record query time. 4. create indexes by file 'create_index.sql' in attachment. 5. repeat step 3. You can find that whether or not index created, influence on query time is paltry. ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2008-06-19 05:57 Message: Logged In: YES user_id=43556 Originator: NO This is to be expected as the indices you create are already created to support the primary keys. I you want to improve the performance, also create foreign keys. This can be done using the create script c.sql-dec-primary-foreign or on your current setup using the alter.sql script. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1997434&group_id=56967 ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
