Tim

Can the execution plan be enhanced to show what type of index is being taken advantage of?

I tried a simple query in a not very big table. _name is defined as ANSI_CI, there is one index on it also ANSI_CI

I tried 3 formats and got these results

where _name = 'homebase'
"_name" = 'homebase' [Index scan: 14 keys, 4096 bytes estimated cost]

where _name  collate ansi_ci = 'homebase'
"_name" COLLATE "ansi_ci" = 'homebase' [Index scan: 14 keys, 4096 bytes
estimated cost]

where _name  collate ansi = 'homebase'
"_name" COLLATE "ansi" = 'homebase' [Row scan: 185 rows, 51800 bytes estimated
cost]

For the first two it would be nice if it said something like
[Index scan (ANSI_CI): 14 keys, 4096 bytes estimated cost]

Roy Lambert

Roy,

<< Can the execution plan be enhanced to show what type of index is being
taken advantage of? >>

Sure, it's on the list for 2.0 as one of the "minor" items.  I'll basically
be adding the index name being used for index scans in the plans.

--
Tim Young
Elevate Software
www.elevatesoft.com