General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>Can I create an index based on an integer & a date field? Actually, the integer refers to the primary key (unintelligent) of another table.
>>
>>Thanks.
>
>Yes, use STR(IntegerField) + DTOS(DateField) as the key for the index
Actually, I have 3 tables. Table 1 parent of table 2 & table 2 parent of table 3. I want to create an index in table 3 that is on the primary key of table 1 plus a date field. Can the table 3 index expression be
STR(table2.integerField) + DTOS(table3.DateField)
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only