|
Ouch, ouch, and ouch! Thanks for the warning! Now, then, you said "SQL indexes are NOT __normally__ shared." (_my emphasis_) Is there a way to get them to be shared? On 7/5/05, Mark S. Waterbury <mark.s.waterbury@xxxxxxx> wrote: > You should be careful if you have many logical files that share access > paths, because the "rules" for how access paths may be shared are much > stricter for DDL, to conform to ANSI standard SQL. So, if you just "close > your eyes and step on the gas" and convert all of your PFs to SQL DDL and > then attempt to convert all of your LFs to a view and an index, the SQL > indexes are NOT normally shared. This could mean that you will now incur > much more overhead in index (access path) maintenance. <snip> - Dan
As an Amazon Associate we earn from qualifying purchases.
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
