Bugs item #1997434, was opened at 2008-06-19 12:55 Message generated for change (Tracker Item Submitted) made by Item Submitter 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: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: David Wung (fivecolor) Assigned to: Nobody/Anonymous (nobody) 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. ---------------------------------------------------------------------- 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
