×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Gerald -
I would not put the select/omit logical on the SQL index - see answers
inline.
-sjl
"Gqcy" wrote in message
news:mailman.2171.1366137261.7202.midrange-l@xxxxxxxxxxxx...
I am reading about converting my DDS files to SQL...
Most of our Logical files are doing both, ordering and record selection...
However I am reading that I should _only_ create indexes for my ordering.
I see I and put in a where clause for my indexes, but should I?
Should I create SQL indexes just on ordering?
Correct.
will the Logical files share the index, even though the logicals have
select/omit logic?
You should probably re-create each of the LF's as a view containing the
select/omit logic.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
