some more questions about indexes in sapdb: say I have a table
PAGEVIEW( ID VARCHAR(32), DAY INTEGER, MONTH INTEGER, YEAR INTEGER, LOGIN VARCHAR(50), COUNTRY CHAR(4) SECTION VARCHAR(100) ... more columns ... ) this table has a lot of records. some of them select records by YEAR, MONTH, LOGIN, some by YEAR, MONTH, COUNTRY, some by YEAR, MONTH, SECTION and lots of other combinations (in some cases joined with other tables). a few questions come to mind: - is the most sensible approach to define an index for each combination I know of and see what happens? - can too many indexes confuse the optimizer and lead to bad strategies even with optimizer statistics up to date and if yes how likely is that. what I'm essentially asking is, do I have to do this the trial-and-error way (lots of work because of the number of permutations of possible indexes) or are there some heuristics that I could use to take a shortcut. currently I have a single index on each of theses columns but for some queries I get the impression the system could perform better (not a very precise assessment, I know :-). Thanks in advance, Robert _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
