Database Tuning (MOSC)

MOSC Banner

how can i choose between char and varchar

edited Jan 29, 2014 6:30AM in Database Tuning (MOSC) 6 commentsAnswered
recently meet a issue that a table has almost 100k rows record, some columns are defined with char, meanwhile create trim(cloumn) function index on it in order to improve the query performace, is that right comparing to the normal index on varchar column type? thanks a lot

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center