All Forums Database
ronit 3 posts Joined 02/06
09 Feb 2006
explain plan

Hi,Where can i find a didtailed explain on the explain plan.How tera decides when to use the index and when not? ThanksRonir

09 Feb 2006

This needs a long discussion, but anyways if you run the explain check for words like"By way of primary index" (rows are read using primary index column(s))"By way of index number" (rows are read using secondary index)"BMSMS" Bit map set manipulations .. using NUSI columns.

You must sign in to leave a comment.