General information
Category:
Coding, syntax & commands
>In 'set relation to' - is is a must to have an index on the parent table?
>
>I have tried, after SQL Selecting data into a cursor, indexing on the relational field, but I keep getting 'xyz.idx already exists - overwrite it? yes/no', so I tried it without creating the index
>and it still seems to work, but I want to know if there are gotchas down the road when it a production environment.
>
>Many thanks!
John,
No you dont, but afterall why shouldn't you? Any specific reason not to have an index on that relational field?
Koen
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