473,395 Members | 1,692 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

indexing

hsn
237 100+
hello everyone i have a simple question to ask you.....

i want to learn indexing more and more and to understand it fuly
because i am studying it now and i keep finding some problems in calculating the cost. and a little problem in choosing the bst way to index the attributes in a given query

so what i need is a website to explain everything i need.
and by the way i don't need a website to explain how to code it. just a website to understand the above questions.

i'm studying hash indexing, B*tree clustered and nonclustered.

thank you

and please help me..............

hsn
Dec 17 '07 #1
4 1344
amitpatel66
2,367 Expert 2GB
hello everyone i have a simple question to ask you.....

i want to learn indexing more and more and to understand it fuly
because i am studying it now and i keep finding some problems in calculating the cost. and a little problem in choosing the bst way to index the attributes in a given query

so what i need is a website to explain everything i need.
and by the way i don't need a website to explain how to code it. just a website to understand the above questions.

i'm studying hash indexing, B*tree clustered and nonclustered.

thank you

and please help me..............

hsn
Here is what you will find everything about indexes, from simple one to partitioned indexes and its usage
Dec 18 '07 #2
hsn
237 100+
Here is what you will find everything about indexes, from simple one to partitioned indexes and its usage
you didn't get what i wanted
i don't need anything related to coding what i need is very simple
is to choose what type of indexing to use on which query
so if
select * from student s where s.id=333.
sid is unique
so here i will say i will use unclustered hash indexing.
so i need a website that will show these kind of points and give me some examples like those.
Dec 21 '07 #3
debasisdas
8,127 Expert 4TB
you can easily find all that by following any book or by investing siome time in web searching.
Dec 22 '07 #4
You have to analyze each situation independently and decide on the best indexing scheme for that scenario. There are so many variables to consider that there is no way anybody is going to come up with a website that completely answers your question. If there were rules of thumb for indexing, don't you think the software would figure it all out "automagically" for you?

I highly suggest you go through the Oracle documentation (if you haven't already), and here's a few really good books to read.

Jonathan Lewis: Oracle Cost Based Fundamentals

Tom Kyte: Effective Oracle by Design

Tom Kyte: Expert Oracle Database Architecture
Dec 23 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

21
by: Hilde Roth | last post by:
This may have been asked before but I can't find it. If I have a rectangular list of lists, say, l = ,,], is there a handy syntax for retrieving the ith item of every sublist? I know about for i...
15
by: Jay | last post by:
Hello all. I've recently transferred our web sites from a Windows2000 server to a Windows2003 server. The transfer went almost flawless until I noticed that our search function isn't working...
1
by: Danny | last post by:
sorry for posting a question that has probably been posted hundreds of times, but i can't seem to find the answer i need...We're using a Sql Server 7.0 database and recently started getting timeout...
108
by: Bryan Olson | last post by:
The Python slice type has one method 'indices', and reportedly: This method takes a single integer argument /length/ and computes information about the extended slice that the slice object would...
10
by: Lyle Fairfield | last post by:
By default mdb etc files are not searched by Indexing Service. The default can be changed in Windows XP Pro using Group Policy. I can find no suggested way to make the change in the Windows XO...
7
by: Ryan | last post by:
I have a bit of a problem with regards an indexing strategy. Well, basically there is no indexing strategy on a set of data I have at work. Now, I didn't create the design as I would have allowed...
3
by: Chung Leong | last post by:
Here's the rest of the tutorial I started earlier: Aside from text within a document, Indexing Service let you search on meta information stored in the files. For example, MusicArtist and...
4
by: Emin | last post by:
Dear Experts, How much slower is dict indexing vs. list indexing (or indexing into a numpy array)? I realize that looking up a value in a dict should be constant time, but does anyone have a...
4
by: pratimapaudel | last post by:
I have tables in my database, it's sql server 2005. I heard some of them have indexing and some of them doesnot have indexing. If i want to check whether it has indexing or not how do i do? ...
2
by: =?Utf-8?B?SmVycnkgQw==?= | last post by:
I have a server 2008 IIS 7.0 with indexing service installed. I have created the catalog and have a test page using these posts:...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.