His question did not clearly state what needed to be clarified. For those that don't know, a clustered index is used to physically store the records in a table in the order of your index. Like a telephone book. In almost all cases, a clustered index is what you want on your tables that contain data you do more looking up on, than updating. If you have a table that you do lots of updating on (say, a stock ticker table) a clustered index may not be the best bet as the logic to manage the clustering will take extra time because the entire row must be stored to a different location to keep order. Most DBMS's allows you to specify which type of index you want. Rbase's SQL does not, and may always assume you are creating a clustered index. I would enjoy someone's input on how Rbase physically stores an index.
Here are two articles about the index types in their relevance to performance on SQL Server. (Clustered and Non-Clustered indexes are not MS SQL Server specific, Sybase, Oracle, etc support them also) http://www.sql-server-performance.com/clustered_indexes.asp http://www.sql-server-performance.com/nonclustered_indexes.asp > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On > Behalf Of Bernie Corrigan > Sent: Saturday, October 06, 2001 5:34 AM > To: [EMAIL PROTECTED] > Subject: RE: RE: Name length limitation - personal correction > > Eric - > You haven't answered Ben's question: What are > clustered/non-clustered indexes as related to RBase and Sql? Or in other > words, what is the difference between clustered and non-clustered indexes? > > Bernie > ======================================= > At 11:02 AM 10/5/2001 -0500, you wrote: > >The application sets up the tables it needs inside the database you > >specify. In my case, Rbase via Oterro. The commands the application > >use specify whether the index is a clustered or a non clustered index. > >Rbase considers it an invalid command. This is in addition to the fact > >that the application needs column names larger than 18 characters, so it > >doesn't matter in the grand scheme of things. It would be nice if the > >application let you specify your own table names, but that would require > >much more work on their end and I don't blame them. > > > >> -----Original Message----- > >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > >On > >> Behalf Of Ben Petersen > >> Sent: Friday, October 05, 2001 2:54 AM > >> To: [EMAIL PROTECTED] > >> Subject: RE: RE: Name length limitation - personal correction > >> > >> Eric, > >> > >> What are clustered/non-clustered indexes as related to RBase and > >> Sql? > >> > >> Ben Petersen > >> > >> > >> > >> On 4 Oct 2001, at 14:19, Crued @ Crued.net wrote: > >> > >> > It's not the VarChar that prevents the creation of the tables, it's > >that > >> > it uses CLUSTERED and NONCLUSTERED Indexes. Having so many problems > >> > getting this working that I failed to think about what the problem > >> > really was. > >> > > >> > I think this means I owe someone a quarter, or a pair of socks or > >> > something, but I'm not sure how that works. :) > >> > > >> > Eric > >> > > >> > > >> > > >> > >I find it extremely frustrating and downright lame that Rbase only > >> > allows >18 char column and table names. In addition to that > >horrible > >> > limitation, I >found another. Rbase doesn't use standard SQL > >datatypes, > >> > so the automatic >table creation from the Fax application does not > >work. > >> > Where it would say >MyKey VARCHAR(19), Rbase wants MyKey TEXT 19. > >> > Lameola. > >> > > >> > > >> > > -----Original Message----- > >> > > From: [EMAIL PROTECTED] > >[mailto:[EMAIL PROTECTED]] > >> > On > >> > > Behalf Of Albert Berry > >> > > Sent: Thursday, October 04, 2001 1:28 PM > >> > > To: [EMAIL PROTECTED] > >> > > Subject: RE: RE: Name length limitation > >> > > > >> > > I was asking if the fax program itself had a db, in which you > >could > >> > create > >> > > a view - but it looks like that is not what happens at all. In > >this > >> > case, > >> > > your best bet might be to create a M$ acce$$ db to receive the SQL > >> > > statements and SATTACH the acce$$ db to the R:Base db. > >> > > > >> > > > >> > > "Crued @ Crued.net" <[EMAIL PROTECTED]> wrote: > >> > > > >> > > >The fax program's source database would be our Rbase database. I > >> > could > >> > > >create a view inside the Rbase DB, but I'm not sure what you are > >> > getting > >> > > >at doing with it. Due to the fact that the Fax application > >issues > >> > > >direct SQL to the ODBC driver, I don't think wrapper views would > >> > work. > >> > > >If you are thinking of some other solution, please let me know as > >I'm > >> > > >screwed otherwise. > >> > > > > >> > > >Thanks, > >> > > >Eric > >> > > > > >> > > > > >> > > >> -----Original Message----- > >> > > >> From: [EMAIL PROTECTED] > >> > [mailto:[EMAIL PROTECTED]] > >> > > >On > >> > > >> Behalf Of Albert Berry > >> > > >> Sent: Thursday, October 04, 2001 12:28 PM > >> > > >> To: [EMAIL PROTECTED] > >> > > >> Subject: RE: Name length limitation > >> > > >> > >> > > >> Can you create a view in the fax program source database that > >> > renames > >> > > >the > >> > > >> fields to 18 characters or less? > >> > > >> > >> > > >> > >> > > >> > >> > > >> "Crued @ Crued.net" <[EMAIL PROTECTED]> wrote: > >> > > >> > >> > > >> >Our Fax program can use an ODBC source for archival purposes. > >The > >> > > >> >tables that it uses are hard coded into their program, and > >some of > >> > > >the > >> > > >> >field names are longer than 18 characters. > >> > > >> > > >> > > >> >Is there anyway around this? > >> > > >> > > >> > > >> >Thanks, > >> > > >> >Eric > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > >> > > >> > >> > > >> > >__________________________________________________________________ > >> > > >> Your favorite stores, helpful shopping tools and great gift > >ideas. > >> > > >> Experience the convenience of buying online with Shop@Netscape! > >> > > >> http://shopnow.netscape.com/ > >> > > >> > >> > > >> Get your own FREE, personal Netscape Mail account today at > >> > > >> http://webmail.netscape.com/ > >> > > > > >> > > > > >> > > > >> > > > >> > > __________________________________________________________________ > >> > > Your favorite stores, helpful shopping tools and great gift ideas. > >> > > Experience the convenience of buying online with Shop@Netscape! > >> > > http://shopnow.netscape.com/ > >> > > > >> > > Get your own FREE, personal Netscape Mail account today at > >> > > http://webmail.netscape.com/ > >> > > >> > > > > >
