Home Forums SQL Server 7,2000 Performance Tuning Bookmark Lookup Options... RE: Bookmark Lookup Options...
SQL ORACLE
One Orange Chip
Points: 27807
More actions
April 9, 2008 at 3:05 pm
#800651
VARCHAR(50) and DECIMAL(18) are not good candidates for indexing. If you cannot modify indexes, you may not have choice.
In principle, data type of column chosen to be indexed should not be long in byte.