-
I have a varchar2(1000)
I need to create index on this field
The data in this feild is probably 50 characters long
I understand that varchar2 does not allocate all 1000 characters .
Is there any performance difference if this field was varchar2(60)?
DOes ther performance matter if this field was indexed ?
-
I think it shouldn't make any performance difference.
Sanjay
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|