I am experimenting with using BINTOC() on some integer indexes. I have a table I expect to be very large and would like to make the indexes as compact as possible.
I added 15,000 dummy records to my test table and checked the CDX file. It was 279,552 bytes for just integer keys.
I changed all four index expressions to BINTOC( ... ), reindexed, refreshed the view in file explorer and expected the CDX file to be smaller, but it wasn't--exactly the same # of bytes.
I am missing something? Thanks.
----------
Mark Bucciarelli